Best Solution for HA/DR

  • We are looking for the best solution for high availability and disaster recovery. We have are main production SQL Server databases and we want to replication to two other servers. One server is in the same building, however, the other server is in another location. We are currently mirroring to the off-site server, but want to add the third server into the environment. Is it possible to mirror a database to multiple SQL instances on different servers?

  • I posted this question under the wrong forum.... I am using SQL Server 2008 R2.

  • Duplicate post. No replies to this thread please. Replies to http://www.sqlservercentral.com/Forums/Topic1301943-1549-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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