Deleting a SQL Database

You can delete a database in a SQL instance if you do not need to protect the database. You can delete one or more databases in a SQL instance. After you delete the database, it is not available for restores. Even though the database is deleted from the backup content and is no longer backed up, it cannot be restored. Previously backed up versions continue to reside on the backup media until retention settings meet.

If you backed up a database that is a part of the Always on Availability group or a subclient on a physical SQL replica instance, then you will need to delete the database twice—from the Availability Group instance and replica node instance.


To prevent accidental deletion of databases, download and deploy the DeleteSQLDatabaseAuthorization workflow.


  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. On the Databases tab, in the row for the database that you want to delete, click the action button action_button, and then select Delete.

    The Delete databases dialog box appears.


    • The Delete option is only available if you have Delete permission for the database.

    • To delete multiple databases in a SQL instance, from the Type list, select SQL server, then select the check box for each database that you want to delete, and then click Delete.

  3. Type DELETE.

  4. Click Delete.

  5. If you have deployed the DeleteSQLDatabaseAuthorization workflow, approve the database deletion request.


The database that you deleted is unavailable for restore operation.