2

Azure SQL Managed Instance became generally available on 1-October, 2018. However, I've seen virtually nothing written about what options we have with regards to fail-over and disaster recovery. Specifically I would like to know what happens in the event of a server failure hosting an MI instance. I would also like to know what happens in the event of a data center failure. Does anyone have information about this?

CHEEKATLAPRADEEP
  • 12,191
  • 1
  • 19
  • 42
Randy Minder
  • 47,200
  • 49
  • 204
  • 358

2 Answers2

1

Currently, Active Geo-replication is not available in Managed Instance.

Note: Active Geo-replication support is coming to public preview very soon.

For more details, refer "Overview:Active geo-replication and auto-failover groups" and "Setup DR with SQL Managed Instance"

CHEEKATLAPRADEEP
  • 12,191
  • 1
  • 19
  • 42
0

Update: Geo-replication for Azure SQL Managed Instance is now in public preview.

For more details, see https://learn.microsoft.com/en-us/azure/sql-database/sql-database-auto-failover-group#best-practices-of-using-failover-groups-with-managed-instances

Brad Crandell
  • 850
  • 1
  • 8
  • 22