1

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?

6

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.

1

Complimenting to Tara's answer ... You should tsql / powershell for availablity group failover.

T-SQL : ALTER AVAILABILITY GROUP MyAg FAILOVER;

PowerShell : Switch-SqlAvailabilityGroup

You should check is_failover_ready in sys.dm_hadr_database_replica_cluster_states dmv to see if the replica is ready for failover and there wont be any data loss.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.