I am looking for a little confirmation here.
While performing and upgrade from Windows 2008 to Windows 2008 R2, I had a failure on one of our nodes. Currently I have three servers in the cluster, two of which hold the working instances, but one which cannot be repaired, so I wish to remove.
I assume I can run setup.exe from the DVD and select “Remove node from a SQL Server failover cluster, but I am leery, as I naturally don’t want to affect the active and passive instances which are behaving properly. As long as I am running the removal process from the server which is not active, and that has the defective install, am I safe? Is this the method I use to remove only one instance from sql server 2008 cluster, so that I can reinstall it anew?