Edit

Azure Arc-enabled SQL Managed Instance - disaster recovery

  • Article

To configure disaster recovery in Azure Arc-enabled SQL Managed Instance, set up Azure failover groups. This article explains failover groups.

Background

Azure failover groups use the same distributed availability groups technology that is in SQL Server. Because Azure Arc-enabled SQL Managed Instance runs on Kubernetes, there's no Windows failover cluster involved. For more information, see Distributed availability groups.

Note

  • The Azure Arc-enabled SQL Managed Instance in both geo-primary and geo-secondary sites need to be identical in terms of their compute & capacity, as well as service tiers they are deployed in.
  • Distributed availability groups can be set up for either General Purpose or Business Critical service tiers.

You can configure failover groups in with the CLI or in the portal. For prerequisites and instructions see the respective content below:

Next steps