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?

ssc 20 Reputation points
2024-03-27T17:51:20.4966667+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,364 questions
0 comments No comments
{count} votes

Accepted answer
  1. Azar 22,355 Reputation points MVP
    2024-03-27T18:13:29.8266667+00:00

    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.


0 additional answers

Sort by: Most helpful