Home Forums Article Discussions Article Discussions by Author Discuss content posted by Perry Whittle Repairing a Broken Log Shipping Plan From a Differential Backup RE: Repairing a Broken Log Shipping Plan From a Differential Backup

  • September 28, 2012 at 1:53 am

    #1543225

    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" 😉