0

Can i use preview feature link for SQL MI as DR site (database) for on-prem SQL Server instance?.We don't want to use the SQL MI for reporting purpose. If the answer is yes, if i failover to SQL MI database as primary in case of DR, when original primary onprem SQLDB comes up, can i failback from SQL MI??

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

Nothing. Looking for an conceptual understanding.

Suresh
  • 9
  • 3

1 Answers1

0

The ability to failback to on-prem is only available in SQL 2022. See The Ultimate Freedom of Movement between SQL Server 2022 and Managed Instance - Microsoft Community Hub

Please let us know if you have further queries.

Oury-MSFT
  • 181
  • 3