SQL Managed Instance Link failback feature issue

Question

SQL Managed Instance Link failback feature issue

Waqar Mustafa 0

Dears,

I would need assistance on Azure SQL Managed Instance Link feature. I have one managed SQL Instance (Primary role) and SQL Server 2022 update 15 running on virtual machine (Secondary role). I performed following steps and worked fine:

Connection b/w SQL Managed Instance and SQL Server 2022 test was successful.
Successfully created link b/w SQL Managed Instance and SQL server.
Failover was successful (SQL Server role changed from Secondary to Primary)

However, failback feature/option did not work as expected (SQL Managed Instance and SQL Server both in read-write mode) even did not receive any error while manually failback through link.

I would need community assistance to guide me on failback procedure please.

Regards,

Anonymous

2024-10-09T17:26:34.18+00:00

Hi @Waqar Mustafa,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

As i understand that, you have successfully set up the Managed Instance Link feature between Azure SQL Managed Instance (Primary role) and SQL Server 2022 (Secondary role), and the failover worked as expected. However, the failback process did not function as intended, with both instances ending up in read-write mode.

I would like to inform you that, The SQL Server 2022 introduces online failover with failback, which allows you to seamlessly failover to Azure SQL Managed Instance and then failback online to SQL Server by using the Managed Instance link, with minimal down time. The option to failback online to SQL Server from SQL Managed Instance is currently in preview.

I would request you to refer the below mentioned links for more information.

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-failover-how-to?view=azuresql&source=recommendations&tabs=tsql

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-disaster-recovery?view=azuresql

https://learn.microsoft.com/en-us/azure/site-recovery/physical-to-azure-failover-failback

I hope this information helps. Please do let us know if you have any further queries.
Anonymous

2024-10-10T17:31:29.04+00:00

Hi @Waqar Mustafa,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Anonymous

2024-10-14T08:37:12.5066667+00:00

Hi @Waqar Mustafa,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.