Forum Discussion
Mirrored On-Premise SQL Server Database not updating
Hi JVDA98,
As nielsvdc already suggested, these are methods to solve your problem.
Perhaps as additional information for us, what version of SQL Server are you using and is it up to date?
I once had a version that was not up to date and performed replication once but then stopped replicating.
I updated the version and then it worked.
It's just one approach, but maybe it will help.
Another phenomenon was that Fabric capacity was stopped at night to save costs and then restarted in the morning. After that, replication did not work either.
If none of that helps, I would open a support ticket if I were you.
Best regards
Feel free to leave kudos or accept it as a solution. This will also help other community members.
We had the same problem with an Azure SQL Database and SQL Server 2019 Database. You mentioned you updated the version and then it worked. But what also happened is services were restarted and then started running correctly again.
Stopping and starting a Fabric capacity while mirroring is in progress might cause issues. Pauzing the mirroring first before stopping the capacity might prevent this issue.
Hope this helps. If so, please give kudos 👍 and mark as Accepted Solution ✔️ to help others.