Azure SQL Managed Instance High Availability Disaster Recovery

Question

Since goal of the high availability architecture in Azure SQL Managed Instance (DBaaS) is to guarantee that database is up and running minimum of 99.99% of time and also three replicas are maintained so can either of the replica be set up across geographic location? This way my database could be protected against regional disaster?

Answer 1

Hello @Anup Kumar

The auto-failover groups allows you to manage the replication and failover of a group of databases on a server or all databases in a managed instance to another region.
I think this architecture sample will help you to understand the concept

https://learn.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell#best-practices-for-sql-managed-instance

Premium tier is deployed on a single node where as Business Critical is also placed on a single node but that node is replicated via zone redundancy with Always On Availability Groups in the same data center via a quorum set.

The Standard/General Purpose service tier uses a separation of compute and storage, which makes high availability and reliability under the arm of the storage architecture, which allows for redundancy across regions, when enabled.

https://social.msdn.microsoft.com/Forums/en-US/137f8f3c-3a44-4919-a214-e547d5d18fc7/sql-managed-instances-and-datacenter-or-region-level-outages?forum=ssdsgetstarted