Use Transact-SQL
To manually fail over an availability group:
- Connect to the server instance that hosts the target secondary replica.
- Use the ALTER AVAILABILITY GROUP statement, as follows:ALTER AVAILABILITY GROUP group_name FAILOVER
- In the statement, group_name is the name of the availability group.The following example manually fails over the MyAg availability group to the connected secondary replica:
ALTER AVAILABILITY GROUP MyAg FAILOVER;
Comments