7

I created a windows 2008 r2 failover cluster for a sql 2008 active/passive cluster. This two node cluster was using a SAN device for a quorum disk resource as well as MSDTC resource.

Well....I decided to reconfigure the SAN device, but I didn't destroy the cluster first. Now that the quorum disk and mstdc disk are completely gone, the cluster is obviously not working. But, I can't even destroy the cluster and start again. I've tried from the Windows Clustering tool, as well as the command line. I was able to get the cluster service to start using the "/fixquorum" parameter. After doing this I was able to remove the passive node from the cluster, but it wouldn't let me destroy the cluster because the default resource group and msdtc are still attached as resources. I tried to delete these resources from both the GUI tool, as well as command line. It will either freeze for several minutes and crash the program, or once it even BSOD'd the server.

Can someone advise on how to destroy this cluster so I can start over?

Improve this question
1
  • Is uninstalling SQL server an option?
    – David
    Jan 30, 2015 at 0:07

1 Answer 1

Reset to default
1

I have seen this also in the past when I deployed a failover cluster. One time I fixed it by executing the following PowerShell command: Remove-ClusterNode After that I executed the following command to clear the configuration on the node: Clear-ClusterNode You have to start the Windows Powershell Modules from the Administrative Tools otherwise these commands won't work. After that I was able to succesful join it to the cluster

If these commands don't work, I'm afraid you have to reinstall the operating system on each node of the cluster.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .