Renaming a cluster node

[mytelecoms]

I believe it's not possible to rename a cluster node, so is the only workaround having to remove the node, format and rename it, then add it back to the cluster?

We have recently changed our naming convention, and need to rename all of our cluster nodes as part of the change. All of our clusters are two-node SQL 2000 active/passive. We'd need to rename both nodes in each cluster.

Has anyone done this before? Is it just a case of removing one node at a time, and then adding them back in, formatted, with the new name?

On another note, we're going to upgrade our nodes to Windows
2003 soon, so I guess this could all be done at the same time.

Thanks in advance

Chris

 

[mrdenny]

I'd wait until after you move to Windows 2003. Clustering is much easier with Windows 2003.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mytelecoms]

Thanks for the quick response.

I believe clustering is much improved in 2003, and I'm told we could expect performance increases of up to 25%. Do the improvements include the ability to rename a node, though?

 

[mrdenny]

Honestly, I'm not sure. I've never tried.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com