How do I remove groups on a SQL Server 2 instance cluster?

Question

How do I remove groups on a SQL Server 2 instance cluster?

RonKin

SSCommitted

Points: 1948
More actions
April 26, 2010 at 9:33 am

#231989

I have a two node cluster. I tried to do a failover to node2, the failover didn’t work. I now need to remove the group. Here is what I currently have: SQLCLUSTERTEST>Cluster Group>SQLCluster Test1 and SQL Cluster Test2. Which group(s) should be removed and how do I go about removing it/them?
Thanks,
RonKin

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 1

Do you want to remove the group just because it didn't fail-over or is the error on why it failed leading you to something?

What OS version are you running?

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

RonKin SSCommitted Points: 1948 More actions · Answer 2

I need to remove the groups because of the messgae I receive; Virtual Server name already exists on the network. To proceed, enter a unique Virtual Server name. I am unable to enter a unique virtual Server NameSQL Server 2005 Ent x64), because it has been setup as a test cluster. The OS is MS Windows 2003 R2 Ent. x64. This is the reason that I need to remove Groups SQLTest1 and SQLTest2.

Thanks,

RonKin

RonKin SSCommitted Points: 1948 More actions · Answer 3

I also need to know how to remove SQLTest1 and SQLTest2 from the SQLTESTCLUSTER.

Thanks,

RonKin

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 4

If this is a test setup I would probably just start over, unless something dictates otherwise I prefer to start clean instead of bandaiding something (especially if it is just a test environment).

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

RonKin SSCommitted Points: 1948 More actions · Answer 5

Thanks. I know I need to start from the beginning but how do I get rid of the SQLTEST1 and SQLTEST2 groups plus the server names within the cluster? For example: CLuster Administrator>SQLCLUTest(remove)>SQLTest1 (remove) and SQLTest2 (remove).

Thank you,

RonKin

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 6

http://support.microsoft.com/kb/282227

This has instruction on cleaning up a cluster service, basically removing the node from the cluster.

To remove the groups you will need to take the node offline and then I believe it allows you to delete it.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

RonKin SSCommitted Points: 1948 More actions · Answer 7

Thank you Shawn for staying with me and helping me out.

KR,

RonKin

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 8

RonKin (4/26/2010)
Thank you Shawn for staying with me and helping me out.

No problem. I don't mess with cluster admin much, I'm usually involved after the OS side is setup. So I don't know how far I will be able to take you :-D.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

RonKin SSCommitted Points: 1948 More actions · Answer 9

One more question then I will be done. I am currently looking in the registry under HKey_LOCAL_Machine>Groups>NodeName = SQLTEST1, can I delete the node name?

Thanks,

RonKin

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 10

I can't advise you to do it;-), but I have had to go through and delete the existance of the node name in the registry so it would let me use it again, so far I have had no issue with it. I however can't recall what keys I actually deleted.:w00t:

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton