SQL Server 2014 Availability Group failed
3
votes
1
answer
425
views
I have 3 servers on VMware workstation:
1. Win 2012 R2 as ADDC -Cluster service.
2. Win 2012 R2 as SQL server primary replica .
3. Win 2012 R2 as SQL server secondary replica (auto fail-over).
My Availability group fail in this scenario: When I disconnect primary replica from the network the cluster fail to announce a fail-over to secondary replica when I try to manual fail-over from secondary replica instance I get this error:
however this not the case when I stop primary replica from cluster manager because it will do auto fail-over.
My Availability group fail in this scenario: When I disconnect primary replica from the network the cluster fail to announce a fail-over to secondary replica when I try to manual fail-over from secondary replica instance I get this error:

Asked by danarj
(169 rep)
Aug 16, 2015, 06:58 AM
Last activity: Jul 31, 2025, 12:03 PM
Last activity: Jul 31, 2025, 12:03 PM