question

ramesh 1 avatar image
ramesh 1 asked

script to restore differential backup in sql server 2008

hi team, i am in need of a TSQL Script to restore the daily differential backup, server A primary------------------------------server B seconday daily differential backup copied-----to server B,,i want a script to restore the differentail backup only , any help
sql-server-2008restoredifferential-backup
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
You'll have to restore the full and the differential, unless you leave Database B in a recovering state all the time. Other than that, yep. Books Online is your friend, always.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.