Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2008 - Remove cluster node


SQL 2008 - Remove cluster node

Author
Message
david.alcock
david.alcock
SSC Veteran
SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)

Group: General Forum Members
Points: 259 Visits: 1158
Apologies if this is a daft question (never a good start!)

Had a thought earlier, we have a very simple active passive cluster. One of the nodes went down but failover didnt occur due to the server not going down completely and was still pingable.

It took several restarts but things soon got back to normal. At one point we were considering rebuilding the box, if it was totally broke. What would happen in SQL as I would expect the new build would have to be added as a new node (or do you, can it just carry on?) but if so, how do you remove the old node as you need to be on the same instance to do the remove in memory serves me right?

'Only he who wanders finds new paths'
HanShi
HanShi
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3051 Visits: 3633
The cluster part of a clustered SQL installation is determined by the Windows cluster group. So if a node crashes, you can evict the node in Windows. No additional work needs to be done for SQL Server to not use the node anymore.

When a newly build node is added to the cluster you need to install SQL on the new node by running the SQL "setup.exe" and choose "add a node...". In addition you need to install all service packs and hotfixes (if you haven't used a slipstream installation).

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
david.alcock
david.alcock
SSC Veteran
SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)

Group: General Forum Members
Points: 259 Visits: 1158
Thanks that was the part i was missing that by evicted a node in Windows, you didnt have to do anything in SQL.

Never had the pleasure thus far so wanted to clear that you, which you have, brilliant...thank you!

'Only he who wanders finds new paths'
SQLSACT
SQLSACT
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1456 Visits: 2931
In the case where one of the nodes fail and needs to be replaced:
> Evict failed node
> Add new/fixed node into failover cluster using Failover Cluster Manager
> Run SQL setup specifying "Add Node to SQL failover cluster"
> Patch new/fixed node

Full cluster verification must be run before adding the new/fixed node
MiguelSQL
MiguelSQL
SSC-Enthusiastic
SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)

Group: General Forum Members
Points: 138 Visits: 1088
I''ve done that and I had tons of issues adding the new node, as SQL though it already had that node.
A better, clean way of doing it, would be to remove the node (uninstall SQL) using the SQL wizard, and then evict the node from the cluster, repair all you need to do, add the node back and reinstall the SQL node
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search