SQL Sync group stuck on processing status

Category: azure sqlazure


Michael Yung on Mon, 09 Feb 2015 16:58:39


The sync group below has been stuck on processing since Dec 21th

Azure Product Subscription ID:


Sync Group ID:

0a1a587d-589b-4e7c-9957-f06eb047ba23_East Asia


12/21/2014 1:18:18 AM
Would you please help me to reset the status from backend? Thanks!


Michael Yung


Eric__Zhang on Tue, 10 Feb 2015 01:23:22

Hi Michael,

The Microsoft support engineer will help to solve the problem from backend. Sometime delay might be expected. Your patience is greatly appreciated. Thank you for understanding and support.

Any of the following can result in a sync group being stuck in the processing state.

a)The client agent is offline.
Be sure that the client agent is online then try again.

b)The client agent is uninstalled or missing.
If the client agent is uninstalled or otherwise missing:
1)Remove agent XML file from the SQL Data Sync (Preview) installation folder if the file exists.
2)Install the agent on same/another on-premise computer, submit the agent key from the portal generated for the agent that’s showing offline.

c)The SQL Data Sync (Preview) service is stopped.
1)In the Start menu, search on Services.
2)Click Services in the Programs section of the search results.
3)Find the SQL Data Sync (Preview) service.
4)If the service status is Stopped right-click the service name and select Start from the dropdown menu.

Reference : http://msdn.microsoft.com/en-us/library/azure/hh667321.aspx#ProcessingError


Bowen Wan on Fri, 13 Feb 2015 09:07:12

Hi Michael,

We've just reset the backend status for your sync group. Please check whether it is back to normal.

The root cause might be related to your local agent failed to keep status updated with sync service. We are still further investigation.