Azure SQL Synchronization stucks

Question

Hello,

i have an Azure SQL database which syncs to four local SQL databases automaticly every 30 minutes. After the last successfull sync on Friday (08-01) the sync group stucks with status "in progress" and I cannot stop or restart the process. The log contains no errors, but nothing is synced since Friday.

Can I do anything myself to repair that or should I create a support ticket?

Best regards

Answer 1

Hi,

According to your description, it seems the issue is related to Azure SQL database, I will move this thread to Azure  SQL database Discussions forums to get a better support.

Regards,

Will

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

Hi selmiac,

Sorry to heard that you meet the SQL Data Sync issue. The root cause of sync failed is still under investigating.

Please post the subscription ID and Sync Group ID. 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 your understanding and support.

Regards,
 Sofiya Li

---

Sofiya Li
TechNet Community Support

Answer 3

Hi,

Subscription ID: ab6dbf61-3c24-4923-b30c-b51693d19911

SyncGroup ID: cfe0b957-831b-4efa-b6fa-dddb39fef81d_West Europe

Thank you for your support!

Regards

selmiac

Answer 4

Hi,

From our backend log, it seems your sync group is in normal state now. Could you check it again?

Regards,
Bowen

Answer 5

Hi,

Any updates on the issue ?

Regards,

Mekh.