You can delete a database in a SQL instance if you do not need to protect the database. After you delete the database, it is not available for restores. You can delete one or more databases in a SQL instance.
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.
Important
To prevent accidental deletion of databases, download and deploy the DeleteSQLDatabaseAuthorization workflow.
Procedure
-
From the navigation pane, go to Protect > Databases.
The Instances page appears.
-
On the Databases tab, in the row for the database that you want to delete, click the action button
, and then select Delete.The Delete databases dialog box appears.
Note
-
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.
-
-
Type DELETE.
-
Click Delete.
-
If you have deployed the DeleteSQLDatabaseAuthorization workflow, approve the database deletion request.
Results
The database that you deleted is unavailable for restore operation.