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 |
|
victord
Yak Posting Veteran
64 Posts |
 Posted - 2001-10-11 : 08:00:58
|
| Situation is: I am trying to restore a database on one server unto another serverusing t-sql commands,but getting errors.Below is an example of the script i wrote,is there any reason why this should have errors and if so how best can i achieve this.Restore Filelistonly fromagrprod_11102001goRESTORE DATABASE agrprod_tst FROM agrprod_11102001 WITH RECOVERY, MOVE ' data1 ' TO 'Merlin\\G:\Agressodatabk\agresso.mdf', MOVE 'index1Data' TO 'Merlin\\G:\Agressodatabk\agresso1.ndf',MOVE 'log1' TO 'Merlin\\T:\Agressologbk\Agressolog1.ldf'Error was File 'data1' is not a database file for database agrprod_test. Edited by - victord on 10/11/2001 08:08:14 |
|
|
|
|
|
backup/restore2