Azure database not syncing with SQL Server database

Question

Azure database not syncing with SQL Server database

Mike 0

the notifications say the sync has been triggered but the databases aren't syning and now haven't been for about a week

Mahesh Kurva 10,520 Reputation points Microsoft External Staff Moderator

2025-11-17T07:58:33.09+00:00

Hi Mike •

Greetings!!

It sounds like you're facing some frustrating issues with your Azure database sync not functioning for the past week despite notifications that the sync has been triggered. Here are a few steps to troubleshoot this situation:

Check Sync Group Status: Make sure that your sync group is not stuck in a processing state or showing any error status. If it is, there may be underlying issues with the sync agent or permissions.

Inspect Sync Agent: Ensure that the client agent for SQL Data Sync is online and functioning properly. If it’s offline or missing, you may need to reinstall or start the service.

Review Configuration: Verify that the configuration settings for the SQL Data Sync are correct, including user permissions and database access settings. You can find the relevant permissions here.

Monitor Resource Usage: Utilize the Azure portal to check for resource usage on both source and target databases. High resource consumption could affect sync operations. Consider leveraging the Query Performance Insight feature to identify any long-running queries that may be causing delays.

Rebuild Indexes and Update Statistics: If you suspect that indexing issues might be affecting performance, try rebuilding the indexes and updating the statistics on both the hub and member databases.

Review Common Errors: Go through common error scenarios outlined in the troubleshooting documentation to see if any apply to your situation.

Tombstone Cleanup: If you see messages regarding tombstone cleanup failures, double-check the configuration files for errors and ensure proper permissions are applied.

If the issue continues after trying the above steps, please share the required details in private message for further assistance.

Hope this helps. Do let us know if you have any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Mahesh Kurva 10,520 Reputation points Microsoft External Staff Moderator

2025-11-18T17:40:45.83+00:00

Hi Mike •

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mahesh Kurva 10,520 Reputation points Microsoft External Staff Moderator

2025-11-19T13:29:32.0633333+00:00

Hi Mike •

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.