How To Manual Failover Availability Group In SQL Server

Facebook LinkedIn

In this issue, it shows an example of how to manual failover an AlwaysOn availability group in SQL Server.

The scenario is when you need to do a force failover because your replicas are not synchronized with each other.

Steps to follow

  1. Check for a possible data loss and use the result to proceed or not.
  2. Execute manual failover on the secondary replica.
  3. Resume data movement.

Huge credit to these articles (this, this and this)