Delete a Sync Group (SDS)
Updated: February 12, 2014
If you need to make changes to a SQL Data Sync (Preview) synchronization that cannot be made to an existing sync group, you must delete then recreate the sync group incorporating the changes in the new sync group. This topic walks you through deleting an existing sync group.
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)
- How To: Delete a Sync Group (SDS) - this topic
- Manually Deprovision a Database
- Cancel a Synchronization (SDS)
- Change an Agent's Key (SDS)
To Remove a Sync Group
Do not delete any database in the Sync Group before you remove the Sync Group. If a database in the Sync Group does not exist when you attempt to remove the Sync Group you must recreate the database then synchronize it before you remove the Sync Group.
Navigate your browser to the Azure Management Portal.
Click SQL Databases.
Click Sync (Preview).
From the list of sync groups and client agents, select the sync group you want to remove.
Click the Delete button at the bottom of the page.
Confirm that the database was successfully removed and deprovisioned. See Confirm Success.
Confirm that each database was properly removed and deprovisioned.
Launch SQL Server Management Studio.
For each database that was in the sync group:
Connect to the server that hosts the database you deprovisioned.
Find the database you deprovisioned.
If the database belonged only to this sync group, ensure that there are no tables with “_dss” in the name.
If there are any tables with “_dss” in the name use the deprovisioning utility, DeprovisioningUtil.exe, to manually deprovision the database.
- Connect to the server that hosts the database you deprovisioned.
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