Forum Discussion

JVDA98's avatar
JVDA98
Frequent Visitor
8 months ago

Mirrored On-Premise SQL Server Database not updating

I have a mirrored on-premise sql server. The set-up & connection is working. I can query the mirrored database without any issue, but the database is not being updated by itself. When I stop the re...
data engineering
lakehouse
nielsvdc's avatar
nielsvdc
Super User
8 months ago

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.