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.

nlucero's avatar
nlucero
Advocate I
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.