the process of deleting data sync objects in the cloud is easy.. and followed yo will see all Data Sync local objects remove from your database local.
First check that Data Sync local agent is running ok in the local machine where SQL Server was. You should see all synced databases there in this agent, in your machine. This is the important thing. To chek that is ok, you should be able to connect
with this agent to your local server and their databases if it's ok that's the first step.
Second, using this agent, unsuscribe SQL Server local databases
with the correspondent button, connect and select database in the agent and click Unregister. You should see the message operation succeded or something like that and then you will see no more the database in the agent. This will clear your Data Sync local
database tables and objects.
Once unsusbcribed, it's Azure Data Sync configuration time. Go to your Data Sync in Azure and to the databases node under Sync Groups where appear your participating databases and delete the agent linked to your data sync group (firs delete the database
reference in this node).
When succeded i'ts time to delete the data sync group, if failed, there is an option to force delete in the panel with the graphical representation of databases and connections, in the main graphic area.
That process allowed us to clear all data sync synchronization information.
I hope this could help you. If so, please mark the answer as Answer or as Helpful. Otherwise please if you provide more info I'll be glad in trying to help
The problem is that in the management studio the databases under sync group are showing as synchronizing. This has been going on for the past few hours (even though it is not a very large database) and when I try to unregister the database from the agent
it says the action cant be completed (I assume because it is currently syncing?)
The problem is that after unregistering the database from the agent, it was removed from the azure management console, but the database still shows in the agent with a state of "tombstoned" and a message that says "database has been marked for unregistration
and is awaiting deprovisioning."
there is a deprovisioning utility that gets installed in the same folder as the sync agent. You can use that to clean up everything. you can find the instructions in the same links above under the section: Force Removal
If u have to delete manually, in addition to triggers, sp n tracking tables, there are also user defined table types