Forum Discussion

jmalcober's avatar
jmalcober
Frequent Visitor
2 years ago
Solved

Azure sql managed instance mirror to Fabric - Error

Hello Community, I am facing an issue while attempting to mirror an Azure SQL Database to Fabric OneLake. During the process, I encountered the following error:   The database cannot be mirrored t...
Mirrored Azure SQL Database
  • AndyDDC's avatar
    AndyDDC
    2 years ago

    Hi jmalcober currently only Azure SQL Database is supported with Fabric Mirroring, no support yet for Managed Instance

gcarvalho's avatar
gcarvalho
Frequent Visitor
1 year ago

barcoyolo I'm not sure if you were able to get it to work, but I was finally able to after trying everything under the sun. To be more specific we tried everything until we changed the policy to be Always up to date, that made it work like magic.

 

1. Enable System Assigned Managed Identity

2. Updated the Policy for source Azure SQL Managed Instance configured to "Always up to date"

 

https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-managed-instance-tutorial

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/update-policy?view=azuresql&preserve-view=true&tabs=azure-portal#always-up-to-date-update-policy