Post reply

Log Shipping Question

  • April 20, 2015 at 4:31 am

    #303055

    Hi all

    I have not used log shipping before and find myself in a position where I need to reboot the secondary node and then the primary node and I don't actually need to failover.

    Is there anything I need to be aware of. When rebooting the secondary node I assume the transactions will be held in the primary nodes log till the secondary comes back and just carry on once back up?

    When rebooting the primary node nothing needs to be done and the log shipping will just start again once it has come back?

    Thanks

  • April 20, 2015 at 6:50 am

    #1792002

    Yes, confirmed.

    -- Gianluca Sartori

  • April 20, 2015 at 7:34 am

    #1792021

    OK great thanks

  • April 20, 2015 at 8:00 am

    #1792033

    As long as when primary and secondary are running the SQL Server service and SQL Agent are running they will fire their respective jobs and do what they are supposed to do. Note that some of the activities require access to things such as network, file shares, etc. as well.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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