Removing a clustered instance from an SQL Server instance

Before you begin

• The clustered instance you want to remove has only one node.
   A clustered instance cannot be removed until it contains only one node. If the instance has more than one mode, remove nodes until only one remains.
• There cannot be any databases managed by BMC Database Automation on the instance.

To remove a clustered instance of SQL Server instance

1. From the Management Console, navigate to the Windows cluster 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, enter the Domain, Username and Password of an account with administrator privileges for all nodes in the cluster in the Administrator Account section, 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 Job options as follows, 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. 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.

9. Click Remove SQL Server Instance.

10. Type Yes (this field is not case sensitive), and click OK when you are prompted to confirm your decision.

    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.

11. If this procedure was not successful, see Troubleshooting.