InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 05:59:21 GMT20http://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspxNice article.Tue, 25 Dec 2012 08:36:21 GMTNeha05http://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspxI 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.Mon, 03 Dec 2012 12:37:00 GMTdenise.crabtreehttp://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspxVery nice article Perry! Thanks for sharing!Fri, 28 Sep 2012 15:42:27 GMTIgnacio A. Salom Rangelhttp://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspxOk.. unfortunately we do not failback to the primary with data. The primary is left usable and running during the DR test and the standby is opened just for the duration of test then resyncronized with a full backup and new log shipping jobs. that is the policy. Steps are we drop logshipping, open the standby, and at the end of the test resync the standby and resetup logshipping. I was hoping that if we stopped the jobs on the primary(instead of dropping) that after the test was done I could take a differential backup, resync the standby with this backup and let then let the log shipping jobs run. This is a big database and takes a long time recyncing from a full.. Thanks for getting back!Fri, 28 Sep 2012 05:18:45 GMTkaren_jonesdbahttp://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspx[quote][b]karen_jonesdba (9/27/2012)[/b][hr]Could this be used for a site to site DR test[/quote]Not really, no.[quote][b]karen_jonesdba (9/27/2012)[/b][hr]Could we instead stop the log shipping jobs (bkp,copy,restore), open the standby for the users to test, take a differntial backup of the primary and use that to restore the standby, then restart the log shipping jobs.[/quote]No, the process above has the wrong ordering. You would need to follow along the lines of[ul][li]stop all Log shipping jobs (backup, copy, restore and alert)[/li][li]run the copy job and then the restore job to ensure that any remaining log backups are restored to the secondary.[/li][li]take a tail log backup on the primary, this will leave the primary database in the restoring state[/li][li]restore tail log backup to the secondary with recovery bringing the database online[/li][/ul]Perform the same again on the new primary to switch back to the original primary and then re enable the Log Shipping jobsFri, 28 Sep 2012 01:53:20 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspx[quote][b]mohammed moinudheen (9/27/2012)[/b][hr]Very good one Perry. Rated it 5 star :)[/quote]Hey thanks Mohammed, appreciate the feedback ;-)Thu, 27 Sep 2012 23:42:53 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspxVery good one Perry. Rated it 5 star :)Thu, 27 Sep 2012 19:41:34 GMTmohammed moinudheenhttp://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspxdatabase has once a day full backup and hourly log backup. No diff. log shipping is for every one hour. Secondary fails at restore due to out of sync lsn.Thu, 27 Sep 2012 13:16:07 GMTkavitha0416http://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspxCould this be used for a site to site DR test where the standby database is opened with recovery for the users to test and then log shipping is rebuilt from scratch by taking a backup of the primary and reinitializing the standby? Could we instead stop the log shipping jobs (bkp,copy,restore), open the standby for the users to test, take a differntial backup of the primary and use that to restore the standby, then restart the log shipping jobs.Thu, 27 Sep 2012 11:45:02 GMTkaren_jonesdbahttp://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspx[quote][b]joeroshan (9/27/2012)[/b][hr]Great article. Very useful for DBA in production environment.[/quote]Hi, thanks for the feedback, please don't forget to rate the article if you found it usefulThu, 27 Sep 2012 02:27:50 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspxGreat article. Very useful for DBA in production environment.Thu, 27 Sep 2012 02:12:15 GMTjoeroshanhttp://www.sqlservercentral.com/Forums/Topic1365028-1452-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/differential/93482/">Repairing a Broken Log Shipping Plan From a Differential Backup</A>[/B]Wed, 26 Sep 2012 22:35:07 GMTPerry Whittle