Removing an instance of SQL Server

This topic describes how to remove an instance of Microsoft SQL Server.

Before you begin

• There are no any databases managed by BMC Database Automation on the instance.
• The instance already exists and is running.
• Microsoft SQL Server media is installed on the Manager.

To remove an instance of SQL Server

1. From the Management Console, navigate to the Windows host that contains the instance that you want to remove, and select that instance.
2. Select Provision > Remove Instance.
3. In the Remove SQL Server Instance page, review the information, and click Next.
4. In the Job Options page, specify any of the following Job options, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   

5. If the Change Control page displays, provision the following fields, and click Next.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   

   Note

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

6. 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.
7. Specify your verification preferences.
    For additional information, see Understanding pre-verification tests.
   • To continue with database creation after the pre-verification tests have been successfully run without manual intervention, select Automatically Continue If All Tests Succeed.

   • To create the database without having first run the pre-verification steps, select Skip Pre-Verification Tests. 

     Note

     The Skip Pre-Verification Tests option should only be used when you are certain all tests can succeed. The option skips verification and advances directly to the actual provisioning activity.

8. Click Remove Instance. 

   Warning

   This operation permanently removes the SQL Server instance.

9. Click OK when prompted to confirm your decision.
    You see a progress page and a success message after the process completes.  

   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.