Repairing a Broken Log Shipping Plan From a Differential Backup

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Perry Whittle » Repairing a Broken Log Shipping Plan From a...

12 posts, Page 2 of 2

««1 2

Repairing a Broken Log Shipping Plan From a Differential Backup

Rate Topic

Display Mode

Topic Options

Author

Message

denise.crabtree

Posted Monday, December 03, 2012 12:37 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:30 PM
Points: 50, Visits: 61

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

Neha05

Posted Tuesday, December 25, 2012 8:36 AM

SSC-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 »

12 posts, Page 2 of 2

««1 2

Permissions