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 Wednesday, September 26, 2012 10:35 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:54 PM
Points: 6,462, Visits: 13,909
Comments posted to this topic are about the item Repairing a Broken Log Shipping Plan From a Differential Backup

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1365028
Posted Thursday, September 27, 2012 2:12 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 12:43 AM
Points: 630, Visits: 1,290
Great article. Very useful for DBA in production environment.

-- Roshan Joe
*******************************************
Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help
Custom cleanup script for backups
Post #1365086
Posted Thursday, September 27, 2012 2:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:54 PM
Points: 6,462, Visits: 13,909
joeroshan (9/27/2012)
Great article. Very useful for DBA in production environment.

Hi, thanks for the feedback, please don't forget to rate the article if you found it useful


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1365090
Posted Thursday, September 27, 2012 11:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 17, 2014 9:15 PM
Points: 11, Visits: 241
Could 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.
Post #1365419
Posted Thursday, September 27, 2012 1:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 12:53 PM
Points: 3, Visits: 137
database 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.
Post #1365473
Posted Thursday, September 27, 2012 7:41 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, October 16, 2014 2:12 PM
Points: 2,278, Visits: 3,798
Very good one Perry.
Rated it 5 star :)


Mohammed Moinudheen
Post #1365576
Posted Thursday, September 27, 2012 11:42 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:54 PM
Points: 6,462, Visits: 13,909
mohammed moinudheen (9/27/2012)
Very good one Perry.
Rated it 5 star :)

Hey thanks Mohammed, appreciate the feedback


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1365618
Posted Friday, September 28, 2012 1:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:54 PM
Points: 6,462, Visits: 13,909
karen_jonesdba (9/27/2012)
Could this be used for a site to site DR test

Not really, no.


karen_jonesdba (9/27/2012)
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.

No, the process above has the wrong ordering. You would need to follow along the lines of


  • stop all Log shipping jobs (backup, copy, restore and alert)

  • run the copy job and then the restore job to ensure that any remaining log backups are restored to the secondary.

  • take a tail log backup on the primary, this will leave the primary database in the restoring state

  • restore tail log backup to the secondary with recovery bringing the database online



Perform the same again on the new primary to switch back to the original primary and then re enable the Log Shipping jobs


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1365660
Posted Friday, September 28, 2012 5:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 17, 2014 9:15 PM
Points: 11, Visits: 241
Ok.. 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!
Post #1365783
Posted Friday, September 28, 2012 3:42 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, October 13, 2014 11:46 AM
Points: 3,087, Visits: 1,436
Very nice article Perry! Thanks for sharing!




My blog
Post #1366126
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse