Removing a node from an existing clustered SQL Server instance

This topic describes how to remove a node from an existing clustered Microsoft SQL Server instance. Only nodes that are in a passive state can be removed.

To remove a node from a clustered SQL Server instance

1. From the Management Console, navigate to the clustered instance that contains the node that you want to remove, and select that node host.
2. Select Provision > Remove from SQL Server Instance.

3. In the General page, review the information, and click Next.

4. In the Configuration page, enter the domain, user name and password of an administrative user account in the Remote Account Information section, and click Next.

   Warning

   Note

   The administrative user account used in this step must have administrator privileges for all nodes in the cluster.

5. In the Custom Scripts Configuration page, select pre-provisioning and post-provisioning scripts as follows, and click Next.

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

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

   Warning

   Note

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

8. 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.
9. 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.

     Warning

     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.

10. Click Remove Node.
     You see a progress page and a success message after the process completes.