Question

A retail company runs a critical order-processing application on Azure SQL Managed Instance in the East US region using the General Purpose service tier. Leadership requires a documented disaster recovery plan that can recover the database in a paired region if the entire East US region becomes unavailable. The business accepts an RPO of up to 1 hour and an RTO of several hours, and wants to avoid the ongoing cost of running a second always-on Managed Instance replica. Which recovery approach should the architect recommend?

Accepted Answer

Rely on geo-restore, which uses geo-redundant backups to restore the database to a new Managed Instance in the paired region during a regional outage.

Answer

Configure an auto-failover group between two Managed Instances in paired regions to provide automatic replication and failover.

Answer

Enable zone-redundant configuration on the existing Managed Instance so it can survive a full regional failure.

Answer

Use point-in-time restore within East US and configure Azure Backup with a geo-redundant Recovery Services vault.