Question

A financial services company runs a critical order-management application backed by an Azure SQL Managed Instance in the East US region. Compliance requires a documented disaster recovery capability that can bring the database online in a second Azure region within a 1-hour RTO and no more than 5 seconds of data loss (RPO) during a regional outage. The solution must allow the application connection string to remain unchanged after failover and should require minimal manual intervention. Which approach should you recommend?

Accepted Answer

Configure an auto-failover group between the primary Managed Instance and a secondary Managed Instance in a paired region, using the read-write listener endpoint in the connection string.

Answer

Enable geo-redundant automated backups on the Managed Instance and restore to a new instance in the secondary region when an outage occurs.

Answer

Use Azure Site Recovery to replicate the Managed Instance virtual cluster to the secondary region and fail over the underlying compute.

Answer

Configure Active geo-replication to a single secondary database and update the application connection string manually after a failover.