Is it possible to setup disaster recovery solution with a Managed Instance Link and on-premise failover cluster with SQL 2022 Allways On with multiple nodes as primary?

Question

We are looking for an option to set up an Azure Managed Instance Link for our disaster recovery solution.

Is it possible to set up a disaster recovery solution with a Managed Instance Link as secondary and an on-premise failover cluster with SQL 2022 Always On High Availability with multiple nodes as primary?

Answer 1

Hey there ssc

Thats a good question and thanks for using QandA platform.

I think yes, it is possible to set up a disaster recovery (DR) solution using Azure Managed Instance Link as the secondary site and an on-premises failover cluster with SQL Server 2022 Always On High Availability (HA) with multiple nodes as the primary site.

you can replicate databases across these nodes, bolstering data redundancy and facilitating failover within your on-premises environment. and, make an Azure SQL Managed Instance in Azure for disaster recovery purposes.

by using Managed Instance Link, you can securely connect your on-premises environment to Azure, enabling seamless data replication and failover capabilities. Implementing data replication mechanisms ensures continuous synchronization between your primary on-premises site and the secondary Azure site, minimizing potential data loss in case of a disaster.

If this helps kindly accept the answer thanks much.