Re: evicting a node from multi instance cluster



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


"dp" <dp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EE2926D7-7FA2-4CB7-B7C0-D2A59FFC4A58@xxxxxxxxxxxxxxxx
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.

.



Relevant Pages

  • Re: evicting a node from multi instance cluster
    ... thanks tom, it help a lot. ... Even though you are running "setup", ... Setup can also be used if not evicting a node from the cluster. ... I have a three node cluster with three virtual sql server 2005 installed. ...
    (microsoft.public.sqlserver.clustering)
  • Lost data drive from 2003 cluster
    ... Here's the setup: ... however I cannot connect to cluster via Cluster Administrator. ... connect to my virtual instances via SQL Server Enterprise Manager. ... both the Quorumand Datadrives. ...
    (microsoft.public.sqlserver.clustering)
  • Re: evicting a node from multi instance cluster
    ... Steps to remove the inactive node from the SQL Server Cluster ... The installation of RTM is not done via media ... Even though you are running "setup", ...
    (microsoft.public.sqlserver.clustering)
  • 2003 Cluster Lost Data Drive
    ... Here's the setup: ... however I cannot connect to cluster via Cluster Administrator. ... connect to my virtual instances via SQL Server Enterprise Manager. ... both the Quorumand Datadrives. ...
    (microsoft.public.windows.server.clustering)
  • Virtual SQL Server
    ... Can I have another Virtual SQL Server on the existing ... Cluster?. ... Active/Passive two-node Cluster Configuration. ... For example Cluster Name is CLUST1 and VIRTUAL SQL SERVER ...
    (microsoft.public.sqlserver.clustering)

Loading