Leveraging Storage Spaces Direct for SQL Server High Availability
Thursday, July 19, 2018 - click here to learn more
I need to remove one of the SQL Server cluster nodes from our failover cluster configuration. Can you please provide the step by step process to complete this?
A Windows failover cluster is a group of servers that work together to maintain high availability of applications. The basic unit of a cluster is a single computer, also called a "node". Now suppose you have to remove a node from your failover cluster configuration, what are the steps?
To do this, we will run SQL Server setup on the node to be removed from the SQL Server failover cluster. We will choose the "Maintenance" tab in the left-hand pane to proceed with the removal of a node from a SQL Server failover cluster. Follow the steps below.
Removing a node from SQL Server failover cluster
Step 1: I have a two node cluster based on the Windows Server 2012 R2 operating systems where we have SQL Server 2014 installed. We will check both nodes in SQL Server using DMV sys.dm_os_cluster_nodes, so that post node removal we can validate the node was actually removed by comparing the original results with the final results of this query.
We can see both nodes in the above screenshot, so our task is to remove SQL-NODE2 from this failover cluster configuration. To do this copy or mount the SQL Server setup on the server where we will perform the SQL Server node removal. Go to the setup.exe file location, right click on setup.exe and choose "Run as administrator" as shown in the below screenshot.
Step 2: The SQL Server Installation Center window will appear on your screen to proceed with the node removal. Now click on the "Maintenance" option from left pane as highlighted in the figure below.
Step 3: Once you click on "Maintenance" from the left pane, multiple options will be displayed in the right pane for this tab. Click on "Remove node from a SQL Server failover cluster" link in the right pane. Setup will ask you to wait with the below window displayed.
Step 4: The Remove a Failover Cluster Node window will be displayed and it will check the Global Rules for this configuration as per the screenshot below. You can see all the mandatory rules have passed. Now click on the "Next" button to proceed.
Step 5: Once you click on the "Next" button, the "Remove Node Rules" step will be checked. All rules have passed, so we can proceed to the next as shown in the figure below. If any rule fails, it is recommended to fix those rules first then proceed with the node removal.
Step 6: As all rules in the above window have successfully passed, click on the "Next" button to proceed. The next window is the Cluster Node Configuration page. You do not need to do anything here. This window will automatically display the node configuration information like the SQL Server Instance name, SQL Server network name, node names, and features which have been installed for this cluster in the right pane. Just verify the information and then click on the "Next" button to proceed.
Step 7: The next window is the Cluster Network Configuration which will verify the network configuration of the failover cluster. The virtual IP address for SQL Server failover cluster will be listed in the "Address" column along with the subnet mask address and network name. You do not need to do anything here, just verify the details of this failover cluster and click the "Next" button.
Step 8: Once you click the "Next" button, a final window will appear to validate the steps that will be performed. Since we want to remove the node from the SQL Server failover cluster, click the "Remove" button as highlighted in the screenshot below.
Step 9: When you click the Remove button, the node removal process will start and it will show a screenshot as shown below.
Once the node has been successfully removed from the SQL Server failover cluster, you will get this window noting the successful removal of all components and features as shown below. Click on the "Close" button to close the setup windows.
Validate SQL Server Cluster Node Removal
We have successfully removed this node from this failover cluster. We will run the same command as in step 1, so we can determine if SQL-NODE2 node has been removed from this SQL Server failover cluster.
Above you can see there is only one node in the failover cluster which is SQL-NODE1. So we have validated that SQL-NODE2 node has been removed from this SQL Server failover cluster.
- Explore more knowledge on SQL Server Database Administration Tips
- Check out the remainder of the SQL Server Clustering Tips
Last Update: 2016-05-03
About the author
View all my tips