Home Forums SQL Server 2012 SQL 2012 - General AlwaysOn local HA with second site automatic failover. RE: AlwaysOn local HA with second site automatic failover.

  • April 3, 2014 at 6:41 pm

    #1703161

    PHXHoward (4/3/2014)

    I'm thinking of partially contained database so in the case the instance doesn't need to come across, just the database with the contained users.

    Is it true that I would want one cluster node in one data center and the second cluster node in the other data center with a third node in a third data center in order to maintain quorum?

    If it's a single database, then I don't think that's needed. Just use Failover Clustering in Data Center A and setup DB mirroring on that DB for the remote Data Center B.

    --

    SQLBuddy