Sample Header Ad - 728x90

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:
enter image description here however this not the case when I stop primary replica from cluster manager because it will do auto fail-over.
Asked by danarj (169 rep)
Aug 16, 2015, 06:58 AM
Last activity: Jul 31, 2025, 12:03 PM