Azure SQL Managed Instance High Availability Disaster Recovery

Anup Kumar 1 Reputation point

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?

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Andriy Bilous 10,151 Reputation points MVP

    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


    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.

    1 person found this answer helpful.
    0 comments No comments