Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
MS SQL database backup to other site RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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 Karl Friday, October 16, 2015 4:51 PM Looking for the correct forum.
    Thursday, September 10, 2015 3:45 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    The 'Academic Initiatives - General Discussions' forum is for any posts not covered under any of the other forums as related to Microsoft's Academic Initiatives.

    I'd ask in the SQL Server forums over here:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home

    Karl

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
    My Blog: Unlock PowerShell
    My Book: Windows PowerShell 2.0 Bible
    My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})


    • Marked as answer by Dave PatrickMVP Monday, October 19, 2015 5:44 PM
    • Edited by Just Karl Friday, October 23, 2015 2:01 PM
    Thursday, September 10, 2015 2:02 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    The 'Academic Initiatives - General Discussions' forum is for any posts not covered under any of the other forums as related to Microsoft's Academic Initiatives.

    I'd ask in the SQL Server forums over here:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home

    Karl

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
    My Blog: Unlock PowerShell
    My Book: Windows PowerShell 2.0 Bible
    My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})


    • Marked as answer by Dave PatrickMVP Monday, October 19, 2015 5:44 PM
    • Edited by Just Karl Friday, October 23, 2015 2:01 PM
    Thursday, September 10, 2015 2:02 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thank you! I tried searching the appropriate place to post but there is non.
    Friday, September 11, 2015 2:31 AM