Groups | Blog | Home
all groups > sql server clustering > april 2005 >

sql server clustering : Removing Nodes from a Virtual Server?


Chris B.
4/27/2005 7:02:03 AM
I've build a SQL 2000 SP3a cluster on top of an 8 node Windows 2003 cluster.
We've decided to split the cluster up into 2 individual clusters and as such
I'm attempting to remove some of the cluster nodes from the Virtual Server
Definiton (as per the "Adding or Removing a Cluster Node from the Vritual
Server Definition" of
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx#EGAA)

Anyway, I begin the SQL install and get to the Computer Name dialog where I
choose the virtual server name. I click next and the install GUI just
disapears. I check and setupsql.exe is continues to show up as running in
Taskman for about 10 minutes then just finishes up.

Mike Epprecht (SQL MVP)
5/16/2005 12:00:00 AM
Hi

Only 4 Nodes are supported on a cluster by SQL Server 2000. It is a setup UI
limitation.

You need to remove the installation like you installed it, with command
line.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

Mike Epprecht (SQL MVP)
5/16/2005 12:00:00 AM
I have not seen any. It was in a discussion with a developer from the SQL
Server Development Team.

PSS might be able to help.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

Chris
5/16/2005 8:30:03 AM
Anyone have any thoughts on this?

[quoted text, click to view]
Chris
5/16/2005 9:03:53 AM
Hmm, thanks for the quick reply.

I don't believe I installed from a command line, but those few weeks were
pretty crazy :) Can you point me in the general direction of documentation
on the command line syntax? I assume you're talking about using the
sqlrem.bat file?

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