x

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

more ▼

asked Jun 22, 2011 at 10:41 PM in Default

avatar image

ramesh 1
2.2k 66 69 73

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Jun 23, 2011 at 04:12 AM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

(comments are locked)
10|1200 characters needed characters left

Have you looked at RESTORE in BOL?

There is an example at the bottom of that page

more ▼

answered Jun 23, 2011 at 01:14 AM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2221
x134
x15

asked: Jun 22, 2011 at 10:41 PM

Seen: 2991 times

Last Updated: Jun 23, 2011 at 01:11 AM

Copyright 2018 Redgate Software. Privacy Policy