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 without affecting rest of the databases and removing whole job. 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 job retention settings are met.

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

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

    The Overview 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.

    Note

    • The Delete option is only available if you have Delete data permission.

    • 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.

    Since the delete operation happens at the granular database level and not on configurable entities, delete operation is not audited. But custom report SQL Databases Marked Deleted is available and represents information about delete operations.

Results

The database that you deleted is unavailable for restore operation.

Loading...