Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Availability group failover scenario question Expand / Collapse
Author
Message
Posted Monday, February 18, 2013 3:07 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 12:58 AM
Points: 576, Visits: 1,532
Hi all

We are currently implementing AG and have the setup where we have a primary and a witness in Datacentre A and a secondary in Datacentre B using Synchronous commit and automatic failover.

My question is around what happens if we lose Datacentre A. At that point automatic failover would not be possible due to there being no Quorum, so I assume I would have to bring up the AG manually on the secondary, but how can I be sure that there has been no data loss. Would this be handled by SQL and any transactions yet to be committed at Datacentre B would be rolled back, and would the AG Dashboard reflect this?

Thanks
Post #1421117
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse