Sql-server – Manual failover of AAG in SQL Server 2012

availability-groupsclusteringsql server

Just a question regarding manual failovers. Does it matter if we use SSMS to perform the failover vs going to the Failover Cluster Manager and move the role to the secondary node? Is there a preferred method or either one is fine to do?

Best Answer

Do not use Failover Cluster Manager for your failovers. It can cause problems.

Do not use the Failover Cluster Manager to move availability groups to different nodes or to fail over availability groups. The Failover Cluster Manager is not aware of the synchronization status of the availability replicas, and doing so can lead to extended downtime. You must use Transact-SQL or SQL Server Management Studio.