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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

2 Answers

·
Kev Riley avatar image
Kev Riley answered
Have you looked at [RESTORE][1] in BOL? There is an [example at the bottom][2] of that page [1]: http://msdn.microsoft.com/en-us/library/ms186858(v=SQL.100).aspx [2]: http://msdn.microsoft.com/en-us/library/ms186858(v=SQL.100).aspx#restoring_full_n_differential_db_backups
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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.