Skip to content

Latest commit

 

History

History
80 lines (52 loc) · 3.82 KB

manage-availability-group.md

File metadata and controls

80 lines (52 loc) · 3.82 KB
title description author ms.author ms.reviewer ms.date ms.topic ms.custom
Manage Always On availability groups
Describes how to manage Always On availability groups in Azure portal
AbdullahMSFT
amamun
mikeray, randolphwest
10/20/2023
how-to
ignite-2023

Manage Always On availability groups

[!INCLUDE sqlserver]

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 [!INCLUDE ssazurearc] instance, in Azure portal. Specifically you can:

Prerequisite

You have a Contributor role or a Custom role with Microsoft.AzureArcData/SqlServerInstances/AvailabilityGroups permissions in at least one of the Azure subscriptions that your organization created.

Learn how to create a new subscription.

View list of availability groups and status

Follow the steps to view the availability groups that are configured for the [!INCLUDE ssazurearc]:

  1. In your Azure portal, browse to the overview page of the SQL Server enabled by Azure Arc

  2. Select Availability Groups

    Azure portal will display the availability groups configured for the SQL Server instance on the right

  3. 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 [!INCLUDE ssazurearc] 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:

  1. In Azure portal, browse to the overview page of the SQL Server for the secondary replica where you want to fail over

  2. Select Availability Groups tab on the left

    Azure portal will display the availability groups configured for the SQL Server instance on the right

  3. Select the availability group that you want to perform a failover on

  4. 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
  • [!INCLUDE ssazurearc] features are not supported for availability groups on failover cluster instances.

Related content