无法删除具有损坏的数据同步的数据库 [英] Cannot drop a database with corrupt Data Sync

问题描述

我们有一个Azure数据库，其中已经手动删除了Data Sync的所有对象。现在它不会丢弃数据库并抛出以下消息：

ErrorCode：400 ErrorMessage：数据库'XXXXX'无法删除，因为它用作同步
元数据数据库，它仍然包含同步组和/或同步代理。

有没有办法删除数据库？

提前致谢！

解决方案

您好，

我们有一个Azure数据库，其中已手动删除Data Sync的所有对象。现在它不会丢弃数据库并抛出以下消息：

ErrorCode：400 ErrorMessage：数据库'XXXXX'无法删除，因为它用作同步
元数据数据库，它仍然包含同步组和/或同步代理。

有没有办法删除数据库？

提前致谢！

您好，

选中此项：

https://social.msdn.microsoft.com/Forums/en-US/87f067c1-8cf2-4417-81e0-031a8c8710dc/cannot-delete-sync-database?forum=ssdsgetstarted

这就是：

https://blobeater.blog/2018/04/03/azure-sql-database-failed-to-delete-database-nightmare/

https://github.com/vitomaz-msft/DataSyncMetadataCleanup

Hi,

We have an Azure database where all objects for Data Sync have been manually dropped. Now it doesn't let drop the database and throws the following message:

ErrorCode: 400 ErrorMessage: Database 'XXXXX' cannot be deleted because it is used as a sync metadata database which still contains sync groups and/or sync agents.

Is there a way to drop the database?

Thanks in advance!

解决方案

Hi,

We have an Azure database where all objects for Data Sync have been manually dropped. Now it doesn't let drop the database and throws the following message:

ErrorCode: 400 ErrorMessage: Database 'XXXXX' cannot be deleted because it is used as a sync metadata database which still contains sync groups and/or sync agents.

Is there a way to drop the database?

Thanks in advance!

Hi,

Check this:

https://social.msdn.microsoft.com/Forums/en-US/87f067c1-8cf2-4417-81e0-031a8c8710dc/cannot-delete-sync-database?forum=ssdsgetstarted

And this:

https://blobeater.blog/2018/04/03/azure-sql-database-failed-to-delete-database-nightmare/

https://github.com/vitomaz-msft/DataSyncMetadataCleanup

这篇关于无法删除具有损坏的数据同步的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！