Removing a node from a SQL cluster

[lck092580]

I've been searching Microsoft for step by step instructions on how to remove a node from a SQL cluster but couldn't find anything.

I basically have a two node cluster for fail over and we're going to upgrade these servers. So the plan is:

1. take the inactive node offline first
2. add new server to replace that node
3. fail over to the new server
4. replace the old node
5. fail back over to the new node

My problem is that I have all the documents on adding nodes but I can't find any documents on removing it. There's also conflicting comments about evicting nodes or not.

Can anyone shed some light on this? Thanks.

 

[mrdenny]

Open the cluster administrator, and reconfigure the Resource Group to not use the node you are removing.

Within the cluster adminsitrator you should be able to remove the node which will be upgraded.

There is an important step in there. You have to manually reinstall SQL Server on the node which doesn't have it and you have to tell the resource group that it can use that node for failover.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com