Removing Cluster node

I want to remove a node from my SQL Server Cluster using Add/Remove
Programs. the SQL resource is on the node that is remaining. Question:
When I do the actual removal of the node, will SQL stay on line on the other
node, or does it go offline for a short period of time?
Thanks!
Why?
What version of Windows? 2000? 20003? 2000 uses Add/remove for the service,
2003 does not anymore.
In either case use Cluster Administrator to evict the node from the cluster.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Steve" <Steve.sam@.hotmail.com> wrote in message
news:O2bgTM5eHHA.1312@.TK2MSFTNGP03.phx.gbl...
>I want to remove a node from my SQL Server Cluster using Add/Remove
>Programs. the SQL resource is on the node that is remaining. Question:
>When I do the actual removal of the node, will SQL stay on line on the
>other node, or does it go offline for a short period of time?
> Thanks!
>
|||We're on Windows 2003 Enterprise 64 bit
I'm just interested in the SQL part right now. I'm using SQL 2005 Standard.
When SQL is on one of the nodes, I'm experiencing all kinds of problems and
have been unable to resolve the issue so I'm just going to get rid of that
node and build a new one. I know I need to evict the node from Windows
Clustering, but I also want to remove the node from the SQL cluster in the
proper way, which I believe to be through add/remove programs and selecting
the instance of SQL to change. But what I wanted to know was if there is
downtime involved in removing the node from the SQL Cluster (i.e. SQL
Virtual Server)
Thanks!
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:etOxiR5eHHA.4772@.TK2MSFTNGP05.phx.gbl...
> Why?
> What version of Windows? 2000? 20003? 2000 uses Add/remove for the
> service, 2003 does not anymore.
> In either case use Cluster Administrator to evict the node from the
> cluster.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Steve" <Steve.sam@.hotmail.com> wrote in message
> news:O2bgTM5eHHA.1312@.TK2MSFTNGP03.phx.gbl...
>
|||"Steve" <Steve.sam@.hotmail.com> wrote in message
news:e9MVkY5eHHA.2052@.TK2MSFTNGP05.phx.gbl...
> We're on Windows 2003 Enterprise 64 bit
> I'm just interested in the SQL part right now. I'm using SQL 2005
> Standard. When SQL is on one of the nodes, I'm experiencing all kinds of
> problems and have been unable to resolve the issue so I'm just going to
> get rid of that node and build a new one. I know I need to evict the node
> from Windows Clustering, but I also want to remove the node from the SQL
> cluster in the proper way, which I believe to be through add/remove
> programs and selecting the instance of SQL to change. But what I wanted
> to know was if there is downtime involved in removing the node from the
> SQL Cluster (i.e. SQL Virtual Server)
> Thanks!
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:etOxiR5eHHA.4772@.TK2MSFTNGP05.phx.gbl...
>
>
You would use add/remove pgms to destroy the whole SQL Server install, not
just one node.
Cluster Administrator is your friend.