Forum Discussion
Fabric and SQL Azure Mirroring - duplicate data on Fabric side
Option 1 (unplug it and plug it back in) did the trick!
Is it a best practice with mirrored databases to periodically give them a restart like this?
Hi jon_clemens , twhite_cargas
You can try the below steps:
1) Stop and restart Mirroring, this will reseed all the tables.. {the turn it off and on again option}
2) Better option, is to deselect this table in the Mirroring Configuration, save the configuration, then add the table back in again.
If the issue still persists then we need our internal team to investigate on this. So I request you to create a support ticket here: Microsoft Fabric Support and Status | Microsoft Fabric
After creating a Support ticket please provide the ticket number as it would help us to track for more information.
Hope this helps. Please let us know if you have any other queries.
Option 1 (unplug it and plug it back in) did the trick!
Is it a best practice with mirrored databases to periodically give them a restart like this?
Hi twhite_cargas
No - turning it off and on, moves all the data again. Its easy, but an expensive way to fix it.
The issue with duplicate rows might be happening due to a bug. Hence I have escalated the same, and our team is working on this to fix it.
ThanksHi Anonymous,
We're experiencing the same issue with our Fabric database mirror (duplicate records in the mirror, none in the source DB). Is there a further update on this issue?
Turning the replication off and the on again, as you've pointed out, is a time expensive exercise. It's also unclear when/how often this duplication occurs which makes managing the solution impractical.
Thanks
It is also happening on ourside. Any reason for the root cause?
