In this blog post, let’s learn about the error message “41406 – The availability group is not ready for automatic failover. The primary replica and a secondary replica are configured for automatic failover, however, the secondary replica is not ready for an automatic failover. Possibly the secondary replica is unavailable, or its data synchronization state is currently not in the SYNCHRONIZED synchronization state.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
41406 – The availability group is not ready for automatic failover. The primary replica and a secondary replica are configured for automatic failover, however, the secondary replica is not ready for an automatic failover. Possibly the secondary replica is unavailable, or its data synchronization state is currently not in the SYNCHRONIZED synchronization state.
Reason for the Error
To be update soon…
Solution
To be update soon…