Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Repairing a Broken Log Shipping Plan From a Differential Backup Expand / Collapse
Posted Monday, December 3, 2012 12:37 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 1, 2015 3:42 PM
Points: 60, Visits: 81
I did not know of this aritcle -- but when log shipping broke Saturday because of a third party log backup I decided I had nothing to lose if it did not work. I took a differential of the primary and applied it to the secondary with Standby= 'filename' and was very pleasently surprised (happy dance in the kitchen ). Then I kicked off the backup, copy and restore jobs and the alert stopped notification. I am very thankful for the people who programmed the restore and backup processes for SQL server and have made it very robust.

Thanks for the article. I was thinking through the "what would happen if a Full had occurred" and this answered that question.
Post #1392113
Posted Tuesday, December 25, 2012 8:36 AM


Group: General Forum Members
Last Login: Tuesday, June 16, 2015 2:34 AM
Points: 424, Visits: 60
Nice article.
Post #1400069
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse