Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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, November 12, 2014 7:25 PM
Points: 60, Visits: 80
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, April 15, 2013 11:42 PM
Points: 424, Visits: 55
Nice article.
Post #1400069
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse