Monday, February 20, 2012

New database from backup

I am going to build a new website and I have all the data in a sql-backup file - and I have a new installation of SQL Server - how do I install it? I try to use Restore database from SQL Server Manager, but I just get the errors (I think because of that I do not have the database in the server).

I am totally beginner with SQL Server - so coudl anyone help me?

What errors are you getting, exactly?

If you want to restore the database on a second machine (instead of the one where the backup was made), you probably need to modify the path where the files will be stored. On the restore database dialog, go to the second tab and check the file names. (This is in SQL 2000 Enterprise Manager, the dialog may look different on the 2005 version).|||Thanks.
You made my day.

No comments:

Post a Comment