none
MS SQL database backup to other site

    Question

  • Hi,

    I have a microsoft SQL 2008 R2 Standard database in Site A and want Site B to be the back-up just in case Site A losses power for what ever reason or the server on Site A goes down. What would be the best disaster recovery method for this? I have heard of replication, log shipping and mirroring and am thinking to use mirroring. Would this be the best option?

    Thanks!

    • Moved by Just KarlModerator Friday, October 16, 2015 4:51 PM Looking for the correct forum.
    Thursday, September 10, 2015 3:45 AM

Answers

All replies