Cancel a Synchronization (SDS)
Updated: February 12, 2014
Under certain conditions, a SQL Data Sync (Preview) synchronization task can take a long time and you may want to cancel an in process synchronization. This topic covers why you might want to cancel a sync task and how to cancel scheduled or on-demand SQL Data Sync (Preview) synchronizations.
Factors that can cause long synchronizations include:
The Microsoft Azure SQL Data Sync plug-in on the Microsoft Azure Silverlight portal has been decommissioned. Going forward, use the Microsoft Azure Management portal, for Azure SQL Data Sync.
You access SQL Data Sync (Preview) via the SYNC tab under SQL Database at the Microsoft Azure Management portal. The SYNC tab is only available when you have one or more sync groups. See the topic How To: Create a Sync Group (SDS) for guidance on creating and modifying a sync group from this portal.
See the Navigation section below for links to topics you should read before you start and guidance on creating and modifying sync groups.
Modifications you can make to a sync group include:
- Update a Sync Group Schema (SDS)
- Add a Database to your Sync Group (SDS)
- Remove a Database from a Sync Group (SDS)
- Delete a Sync Group (SDS)
- Manually Deprovision a Database
- How To: Cancel a Synchronization (SDS) - this topic
- Change an Agent's Key (SDS)
Why cancel a synchronization?
You would likely want to cancel a synchronization if:
The synchronization was taking too long.
A synchronization could take an inordinate amount of time if:
There are many data conflicts.
You get one data conflict per row when the target database is prepopulated with data. See Initial Synchronization for more information.
The synchronization task includes large databases.
There is a synchronization loop.
If you have a sync loop the number of rows synchronized increases each time, you synchronize. (See Understand and Avoid Synchronization Loops.)
- There are many data conflicts.
There are issues within the sync group that prevent successful synchronizations.
Common issues that prevent successful synchronizations include:
The client agent is offline.
Configuration issues, such as row filtering for columns that are non-null columns so that all rows that apply fail.
- The client agent is offline.
You clicked Sync multiple times, initiating multiple synchronization tasks where only one is needed. (Yes, this does happen.)
You can only cancel synchronization tasks, not provisioning.
How to cancel a synchronization
Navigate your browser to the Azure Platform Management Portal.
Click SQL Databases.
Click Sync (Preview).
From the list of sync groups and client agents, select the sync group whose running synchronization task you want to cancel.
Click the Stop button to the right of the Sync button at the bottom of the page.
Results of canceling a synchronization
The cancelation is successful. Synchronizations are always canceled successfully.
When you click Stop, the current synchronization task is canceled as soon as possible. If a change is being made at the time you click Stop, that change is completed, then the synchronization task is terminated.
A log entry is made – Synchronization canceled successfully – which can be seen using the Log Viewer.
What does not happen
Changes are not rolled back. Therefore, if a synchronization task is canceled once it has started the sync group is partially synchronized.
SQL Data Sync (Preview) is a feature of SQL Database. From the Azure Management portal you can perform all tasks necessary to create, deploy, and modify a sync group.
Before you start
Before you begin to design and implement your synchronizations, you should be familiar with these topics.
How to create a sync group
There are six steps to creating a sync group from the Azure Management portal. Details on each step can be found by following these links.
ConceptsSQL Data Sync
SQL Data Sync (Preview) Community Resources
SQL Database Data Types supported by SQL Data Sync (Preview)
Data Security in SQL Data Sync (Preview)
Conflict Resolution when Synchronizing
SQL Data Sync (Preview)Troubleshooting Guide
Glossary of SQL Data Sync Terms
Other ResourcesKnown SQL Data Sync Issues
Azure Management Portal
SQL Azure Data Sync [Channel 9 videos]
SQL Data Sync Forum