SQL Server 2012 AlwaysON Automatic Failover Set – Caveat
As I was going through the documentation of AlwaysON, I came across the following caveat with SQL Server AlwaysON Automatic Failover set. While we can have upto synchronous secondary replica, we can have only one secondary replica to be part of Automatic Failover Set. Now, what that means is only of the synchronous secondary replica…