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 then end up creating a new record, rather than update the existing record.
Is this a known issue? Any insight or explanations?
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?
