Post reply

Reinitialize log shipping in sql server 2008 R2 after activate Secondary server DB

  • April 15, 2013 at 9:24 am

    #273595

    Hi All,

    I have set up logshipping between server A (Primary) and server B (Secondary), and tested log shipping by activate database from server B ( Stop the log shipping job and Restore database with Recovery on server B) . Now i wanted continue the log shiping from this break point . Can continue without restore the full backup from server A ?

    Please help

    Regards

    Suresh

  • April 15, 2013 at 10:30 am

    #1606539

    afraid not. A restore of an online database has to start with a full restore, so you will need another full backup or use the old full backup again.

    If you have not taken another full backup since the one you initialised with you could take a differential backup of server A, and apply that after reapplying your original full backup.

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

  • April 15, 2013 at 8:21 pm

    #1606672

    Hi george sibbald,

    Thanks, Do you a steps for Full life cycle of Log Shipping ? I wanted steps to follow after activate the server B and tested, than i wanted to set back as stand by mode without restore the full backup again. ( Like a oracle flashback option )

    Regards

    Suresh

  • April 16, 2013 at 1:47 am

    #1606723

    tsdsuresh (4/15/2013)

    Hi All,

    I have set up logshipping between server A (Primary) and server B (Secondary), and tested log shipping by activate database from server B ( Stop the log shipping job and Restore database with Recovery on server B) . Now i wanted continue the log shiping from this break point . Can continue without restore the full backup from server A ?

    Please help

    Regards

    Suresh

    You'll need to configure Log Shipping role switching using this article from Microsoft

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • April 16, 2013 at 2:41 am

    #1606735

    Hi ,

    It's not possible because your LSN has been breaked. And as you know In logshipping without Log sequence number you can't restore.

    Rajesh Singh

    +91-9560888360

    Rajesh Singh
    DBA(HCL Comnet)
    +91-0560888360

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply