Forum Discussion
SQL Server AG Failover - Automatic Failover
Hello, I am looking for a straight and definitive answer that I was hoping someone could answer for me. I want to trust what Copilot says, but I really need to hear it from Microsoft and I can't ...
It supports automatic failure only between one primary and one secondary. Even if you set multiple replicas to automatic, you will see only one is honored. You only need to configure one synchronous secondary with automatic fail over, keep the all others set to manual.