Forum Discussion
Solved
Fabric and SQL Azure Mirroring - duplicate data on Fabric side
We have mirroring setup, and it has been running fine. But then we noticed that we are starting to see duplicate records in Fabric, almost like updates on the SQL side are being seen as changes, but...
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?
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?
It is also happening on ourside. Any reason for the root cause?