Home / server / Questions / 809547
In Process
Louwrens Potgieter
Asked: 2016-10-18 07:05:40 +0800 CST

Cant delete Azure Database

  • 772

Created this a database from a backup.

I want to delete this database because I selected the incorrect backup. When trying to delete the database I get the following error:

Failed to delete the database: [DBNAME]. ErrorCode: 400 ErrorMessage: Cannot use reserved database name '[DBNAME]' in this operation. This is an SQL database.

Steps taken to delette database:

  1. Open Azure Portal.
  2. Select Database ([DBNAME]).
  3. Click delete button.
  4. Get above mentioned error.

Error

Error

Connecting with SSMS: The Database that I want to delete is not there DB not there

sql database azure azure-sql

1 Answers

  1. It sounds like you have used a reserved word in the DB name and for some reason the deletion process in the Azure portal isn't dealing with this. A couple of ways to deal with the immediate issue:

    • Delete the database through SQL Server Management Studio (SSMS)
    • Use SSMS to rename the database to something without a reserved word and then delete it through the portal

    I would also suggest raising an bug with MS as the portal should either handle this, or prevent you from creating the DB in the first place.

    • 1