May 20, 2003 at 4:30 am
I have a pair of W2K SQL2K cluster. The setup is as follows, 1 node is named Virtual1 and the other node is Virtual2\instance2. The storage is giving us lots of problems and we are contemplating breaking up the cluster to standalones. How should I go about "unclustering" this pair. I have read the Microsoft's technet guide on removing a node, but I am not sure if thats what I am supposed to do.
May 20, 2003 at 7:04 am
Removing a node only handles the physical node. The cluster is still intact in that case, just running on a single physical node (I think some refer to this as a Lone Wolf cluster). Unless I'm mistaken, your best bet is to either (a) backup and restore or (b) detach and reattach the DBs from the original virtual servers to wherever you want them to go. Andy Warren has articles on how to move user databases around and Steve Jones has covered the system ones.
Unless I'm mistaken, you can make a non-clustered SQL Server instance clustered, but you can't do the reverse. Anyone ever done what min is trying to do?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
May 20, 2003 at 3:02 pm
To "uncluster" them, backup up all the DBs, detach the DBs, uninstall the virtual instances, uninstall the default instances, and finally uninstall the cluster service.
If it is your desire to keep those two servers as SQL servers, you'll need to reinstall SQL Server and then reattach the user databases.
David R Buckingham, MCDBA,MCSA,MCP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply