SQL Server Performance Forum – Threads Archive

Restoring differential backup on different server

Hi there,
I have been trying (with EM) to restore 2 different database backup files (complete database and post differential backup) on a different server and I am not getting to the point …. is it possible to do so? What am I doing wrong? thx a lot …..

Yes you can restore the good backup on any other server, if the system drives are different to each other you can use WITH MOVE clause in RESTORE statement. As usual to restore the backup you can use:
RESTORE DATABASE <dbname> FROM DISK=’path’ WITH REPLACE To restore multiple transaction log files you must restore database backup WITH NORECOVERY clause and for last set WITH RECOVERY clause. REfer to books online for more information. 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.

Yes, definitely what makes the difference is the WITH NORECOVERY clause …. "To restore multiple transaction log files you must restore database backup WITH NORECOVERY clause and for last set WITH RECOVERY clause.
" In my case, complete backup restore WITH NORECOVERY and differential backup restore WITH RECOVERY thanks again satya

Use WITH RECOVERY for the last set of backup in order to keep database online. 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.

]]>