Forum Discussion
Mirroring Azure SQL DB is not working
I heard back from MS Support about my similar issue. if you
GRANT SELECT, ALTER ANY EXTERNAL MIRROR, VIEW PERFORMANCE DEFINITION TO [User];for the managed identity that is accessing your Azure SQL DB from Fabric, the metadata will not become corrupted using my reproduction steps. This does not, however, correct a DB where metadata has already become corrupted.
Note that the difference between the grant statement above and the official documents is that the official docs do not mention the need for VIEW PERFORMANCE DEFINITION permission.
Hi TimoW
Errroe it self saying your meta data tables corrupted. So, you can try the following database level checks using Dynamic Management Views (DMVs) and stored procedures to validate configuration.
and also as said by you table doesn't have primary key cannot be mirrored. Pls see the below snapshot.
If you need additional info, pls go thorugh the below microsoft documentations. It moght helps you
https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-database-limitations
https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-database-troubleshoot
https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-database-mirroring-faq
Thank you!!!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Hello suparnababu8,
First of all, thank you for responding quickly to my post!
The stored procedures and tables that provide information about the change feed are returning empty results because the fabric link cannot be enabled due to metadata corruption. The issue is that I cannot find any metadata corruption in my database.
I have tried mirroring our development and test databases, and these work as intended as the tables succesfully get mirrored. I also followed all the relevant steps in the documentation you provided, but unfortunately, the error persists.
Any further assistance would be greatly appreciated.
Hi TimoW ,
In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thanks,
Prashanth
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
Please note that as of April 2025, tables can be mirrored even if they do not have a primary key. The documentation is updated in Limitations and Behaviors for Fabric Mirrored Databases From Azure SQL Database - Microsoft Fabric | Microsoft Learn
