Manage Always On availability groups
Applies to:
SQL Server
An Always On availability group is an enterprise level high availability and disaster recovery solution for SQL Server. This article describes how to manage a SQL Server enabled by Azure Arc instance, in Azure portal. Specifically you can:
View list of availability groups and status
Follow the steps to view the availability groups that are configured for the SQL Server enabled by Azure Arc:
In your Azure portal, browse to the overview page of the SQL Server enabled by Azure Arc
Select Availability Groups
Azure portal will display the availability groups configured for the SQL Server instance on the right
Select the availability group that you want to review
Azure portal displays the health and status of the Always on Availability Group similar to the Availability Group dashboard shown in SQL Server Management Studio. This includes:
- The current primary replica
- Availability group state
- Availability group replicas
- Failover mode
- Synchronization state
When the availability group (AG) dashboard loads, fetching the dashboard details is done via a roundtrip down to the SQL Server enabled by Azure Arc instance. The Arc SQL extension agent connects to the SQL Server, queries the AG related DMV (Dynamic Management Views) metadata, and sends the information back to the Azure portal where it is displayed.
Failover
Always On availability groups support different failover modes depending on the data synchronization mode.
- Synchronous-commit mode supports two forms of failover
- Planned manual failover
- Automatic failover
- Asynchronous-commit mode supports forced manual failover (with possible data loss), typically called, forced failover
SQL Server enabled by Azure Arc supports planned manual failover.
Follow the steps below to initiate a planned manual failover:
In Azure portal, browse to the overview page of the SQL Server for the secondary replica where you want to fail over
Select Availability Groups tab on the left
Azure portal will display the availability groups configured for the SQL Server instance on the right
Select the availability group that you want to perform a failover on
In the Availability Group dashboard on the right, select Failover
This will initiate a planned, manual failover on the AG replica.
Considerations
- Currently, manual planned failover is the only mode of failover supported
- SQL Server enabled by Azure Arc features are not supported for availability groups on failover cluster instances.