Forum Discussion

TimoW's avatar
TimoW
Advocate I
1 year ago
Solved

Mirroring Azure SQL DB is not working

Hello everyone,   I am currently testing the mirroring functionality for our Azure SQL Database within Microsoft Fabric. Initially, everything worked fine. Mirroring tables succeeded for those with...
one lake
  • nlucero's avatar
    nlucero
    1 year ago

    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.

suparnababu8's avatar
suparnababu8
Super User
1 year ago

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!