Mirrored On-Premise SQL Server Database not updating

Hi JVDA98, there could be different reasons for the mirroring to be stalled.

• If you used the OAuth2 authentication method for the Fabric connection, you may need to reauthenticate. Then check if the connection is still online, otherwise reauthenticate.
• Your change_feed could be stalled. Stop and start the change feed on the database. Then stop and start the mirroring process again to reinitialize all data. This worked on my mirrored database.

EXEC sys.sp_change_feed_disable_db;
EXEC sys.sp_change_feed_enable_db @destination_type = 2; -- 2 = Fabric database mirroring

-- Check status
SELECT
  name,
  is_change_feed_enabled,
  is_data_lake_replication_enabled
FROM sys.databases
WHERE name = DB_NAME();​

You can also check the site Troubleshoot Fabric Mirrored Databases From SQL Server - Microsoft Fabric | Microsoft Learn.

Hope this helps. If so, please give kudos 👍 and mark as Accepted Solution ✔️ to help others. If you resolved your question, let us know what worked for you.

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.

Hi JVDA98 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you nielsvdc spaceman127  for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.