Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joanne
Starting Member
46 Posts |
 Posted - 2005-03-03 : 08:19:50
|
| Hi, I have a database on one server (db_prod) and I have a copy of this database on a standby server (db_prod) but I don’t have a server for our tests. What I want to do is to use the stand by server for tests and to create a new database db_test.Haw can I restore the backup for db_prod on my db_test?Tanks in advance |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-03 : 08:25:56
|
| In EM, you can just restore your FULL backup giving it a different name in the restore database window, and changing the file locations through the options.Otherwise, something like RESTORE DATABASE db_test FROM <your_backup_device_file> WITH MOVE 'data_file_name' TO 'path:\to\data\file\location'Check the BOL for Restore (described)-------Moo. :) |
 |
|
|
joanne
Starting Member
46 Posts |
Posted - 2005-03-03 : 12:00:36
|
| Hi,All work fine with this:BACKUP DATABASE Northwind TO DISK = 'd:\Northwind.bak'--RESTORE FILELISTONLY --FROM DISK = 'd:\Northwind.bak'RESTORE DATABASE TestDB FROM DISK = 'd:\Northwind.bak' WITH MOVE 'Northwind' TO 'd:\testdb.mdf', MOVE 'Northwind_log' TO 'd:\testdb.ldf'GOMany thanks |
|
|
|
|
|
|
restore database on other name