Removing a database from an instance of SQL Server

This topic describes how to remove a Microsoft SQL Server database from an instance.

Before you begin

The database must already exist and the instance it resides on must be running.

To remove a database from an instance of SQL Server

1. From the Management Console, navigate to the instance that contains the database you want to remove, and select that database.
2. Select Provision > Remove Database.
3. In the Remove SQL Server Database page, review the information, and click Next.

4. In the Custom Scripts Configuration page, select any pre-provisioning or post-provisioning scripts that you want to run as follows, and click Next.

5. In the Job Options page, specify any of the following Job options, and click Next.

6. If the Change Control page displays, populate the following fields, and click Next.

   Note

   The Change Control page appears only when change control is configured for your environment. See Configuring-change-control.

7. In the Summary page, review the provisioning information.
   To make changes, do the following:
   1. Click Go to to return to the provisioning step that you want to edit.
   2. Make your changes.
   3. Click Save and Review to return to the Summary page.

8. Click Remove Database.
   A pop-up window appears asking you to confirm your decision.

   Warning

   This operation permanently removes the database.

9. Click OK.

   Note

   Detailed current and historical information about this action can be viewed in the Jobs section of the Management Console. See Monitoring-jobs-and-viewing-job-history.