Hy All
I have QA Database on Azure,so after using i want to delete it from Azure to lower the cost.
When I delete it it say "sync metadata database" .
I did not understand the error.
I did not understand the error.
Can someone help.
pfa.
Loading
Madan ShekarPosted Nov 5, 2018, 7:20 AM
https://docs.microsoft.com/en-us/azure/mysql/howto-create-manage-server-portal
Logesh PalaniPosted Nov 1, 2018, 3:36 AM
Hi,
1. Local Agent cannot be deleted if its associated on-Premise database is unreachable
Description/Symptoms : If a local end point (database) that is registered with a local SQL Azure Data Sync
agent becomes unreachable, the local agent cannot be deleted.
Cause : The local agent cannot be deleted because the unreachable database is still
registered with the agent and when you try to delete the agent, the deletion
process tries to reach the database, which fails. This database cannot be
unregistered too, because during unregistration process, local agent tries to
connect to database which cannot be reachable.
Resolution/Workaround : Create a local database with the same name as the one that cannot be reached,
unregister this database from local agent, and then proceed to delete the agent.
2. Sync Group cannot be deleted within 3 minutes of uninstalling/stopping the agent Description/Symptoms
You are not able to delete a sync group with in 3 minutes of uninstalling/stopping the associated local SQL Azure Data Sync agent.
Resolution/Workaround : Remove a sync group with associated sync agents online (strongly recommended).
If agent is offline but installed, bring it online on the on-premise computer, wait for the status of the agent as online in Azure portal, and then remove the sync group.
If agent is offline because it was uninstalled, perform the following steps and try deleting the sync group.
-Remove agent XML file from the SQL Azure Data Sync installation folder if the file exists
-Install the agent on same/another on-premise machine, submit agent key from portal generated for the agent that’s showing offline
3. cannot delete my sync group
Description/Symptoms : You fail in your attempt to delete a sync group.
Cause/Fix : Any of the following can result in a failure to delete a sync group.
The agent is offline : Be sure that the agent is online then try again.
The Data Sync service is stopped :
* In the Start menu search on Services
* Click Services in the Programs section of the search results.
* Find the SQL Azure Data Sync Preview service.
* If the service status is Stopped right-click the service name and select Start from the dropdown menu.
A database is offline : Check your SQL Azure and SQL Server databases to be sure they are all online.
The sync group is provisioning or synchronizing : Wait until the provisioning or synchronizing process finishes then retry deleting the sync group.
Hope this helps.