Log Shipping Recovery

  • I have a Server 2008 R2 SQL 2005 server running log shipping to a secondary instance on a back up server. My question is, given total failure on the primary server, how do I get the secondary database up and running for users?

    Thank you for your time,

    Scott

  • copy across any remaining logs if possible, then restore them in sequence. The last restore should be with recovery

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

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