Groups | Blog | Home
all groups > sql server clustering > october 2007 >

sql server clustering : evicting a node from multi instance cluster


dp
10/31/2007 9:14:01 AM
I have a three node cluster with three virtual sql server 2005 installed. Now
I want to take one node out of cluster to make a two node cluster. According
to the post of Daniel ("evicting a node") and other reading, we have to run
the setup again. My question are:
1. do I have to run the setup on all of thre virtual sql servers or just one?
2. after run the setup, will the sql server be changed to RTM? my server
have the sp2 right now.
3. If we can just evicting a node from cluster group without any database
issue, why do we need to run the setup again.
Daniel, can you post what you did in more detail for what you did.
thanks for anyone who cna help.
Regards,
Tom Moreau
10/31/2007 6:05:01 PM
You have to run the setup for each virtual server to tell the cluster to use
only the remaining nodes. The SQL Servers will not be downgraded to RTM.
Even though you are running "setup", it's not installing anything. It's
just configuring.

Setup can also be used if not evicting a node from the cluster. You could
tell it to use only certain nodes within the cluster for a given instance.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


[quoted text, click to view]
I have a three node cluster with three virtual sql server 2005 installed.
Now
I want to take one node out of cluster to make a two node cluster. According
to the post of Daniel ("evicting a node") and other reading, we have to run
the setup again. My question are:
1. do I have to run the setup on all of thre virtual sql servers or just
one?
2. after run the setup, will the sql server be changed to RTM? my server
have the sp2 right now.
3. If we can just evicting a node from cluster group without any database
issue, why do we need to run the setup again.
Daniel, can you post what you did in more detail for what you did.
thanks for anyone who cna help.
Regards,
Zack.
Tom Moreau
11/1/2007 12:00:00 AM
The only risk I'd see is in a 2-node cluster and you evict one node. If you
don't get the new node back into the cluster, then if the last remaining
node fails, you're down. That's why I prefer to add a node before evicting
an old one.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


[quoted text, click to view]
thanks tom, it help a lot. Do you know how long it will take normally and if
it is a risky process or smoth one?
thanks again.

ZP
--
m


[quoted text, click to view]
dp
11/1/2007 9:02:01 AM
thanks tom, it help a lot. Do you know how long it will take normally and if
it is a risky process or smoth one?
thanks again.

ZP
--
m


[quoted text, click to view]
AddThis Social Bookmark Button