Home Forums SQL Server 2008 SQL Server 2008 - General Reinitialize log shipping in sql server 2008 R2 after activate Secondary server DB RE: Reinitialize log shipping in sql server 2008 R2 after activate Secondary server DB

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