syntax using the move command
Posted on 2006-03-29
on a sql2000+sp4 server I am trying to restore from backup the master DB from one server to another, and in a different location on the recovery server, as part of a disaster recovery plan. Working the sql on the second server, I start up in single server mode (sqlservr -c -m) and try to run the following in query analyizer
RESTORE DATABASE MASTER
FROM DISK = 'c:\sql_backup_test\mastermaster_db_200603270200.BAK',
WITH MOVE 'MASTER' TO 'c:\sql\mssql\data\master_mdf',
MOVE 'MASTLOG' TO 'C:\sql\mssql\data\master.ldf,
It is givining me an error of incorrect syntax near the keyword 'with' on line 3 I am not a DB developer and not experienced with SQl. Any help would be appreciated.