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.
TimW - I am having a similar problem, but not identical. I'm performing a routine action (starting and stopping replication) and it's causing my metadata to become corrupted even though there are no changes to my underlying schema. I'm in contact with Fabric support, but no resolution yet. I'll keep you updated.