locked
Cannot Delete Sync Database. RRS feed

  • Question

  • Hello,

    After conducting some tests with Azure DB Sync, we need to delete a Sync database. The database has no group and no agent, but still I cannot delete it.

    The error message says: "Failed to delete the database: bbdd-test-****-syncgroup-metadata. ErrorCode: 400 ErrorMessage: Database 'bbdd-test-****-syncgroup-metadata' cannot be deleted because it is used as a sync metadata database which still contains sync groups and/or sync agents."

    Any help is welcome.

    Thanks!

    Monday, August 20, 2018 10:37 AM

Answers

  • Hello,

    Please use the deprovision tool to make some cleaning and stop syncing

    On the computer where you installed SQL Agent, under the c:\program files (x86)\Microsoft SQL Azure Data Sync directory you should find an utility named deprovisionUtil.exe. If you run it with the switch /F it will remove the DSS schema and all its objects.



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, August 20, 2018 11:45 AM

All replies

  • Hello,

    Please use the deprovision tool to make some cleaning and stop syncing

    On the computer where you installed SQL Agent, under the c:\program files (x86)\Microsoft SQL Azure Data Sync directory you should find an utility named deprovisionUtil.exe. If you run it with the switch /F it will remove the DSS schema and all its objects.



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Monday, August 20, 2018 11:45 AM
  • Thanks, will try.
    Monday, August 20, 2018 12:27 PM