SQL Server Performance Forum – Threads Archive

Restore to different server

If I am restoring a database from a backup file on disk on Server_A to a database on Server_B, in the restore syntax do I need to specify the "with move" clause if the data and log files as backed up on Server_A are going to be restored into differently named directories on Server_B?

Yes and before that run RESTORE FILELISTONLY to get logical filenames and path. BOL is your best friend [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

Just curious, do the data files and such on the originating server remain usable after the restore/move to the destination server? That is, I am creating a backup of production for testing, and I of course want my production database to remain. <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by satya Yes and before that run RESTORE FILELISTONLY to get logical filenames and path. BOL is your best friend [<img src=’/community/emoticons/emotion-1.gif’ alt=’

Yes the files will be usable and if you still need your testing database then you may restore live database as another database. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>