Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was wondering if anyone knew whether it was possible to delete the cluster resource, but keep all of the disks and sql instance running on the node instead? So if I was to delete the cluster resource, would the instance continue running on the node?

share|improve this question
That node won't have any of your databases online or available unless it's the active node. What would be the point? – Aaron Bertrand May 22 '13 at 17:19
Is this question driven by some other administrative activity, or is it hypothetical? If it's the former, I would suggest editing the question to let us know what you're trying to do. – Jon Seigel May 22 '13 at 17:24
What server OS, what SQL Server version? And are you trying to do this in uptime, or fix a broken cluster resource? – Cougar9000 May 22 '13 at 18:07
up vote 2 down vote accepted

No. The instance is configured to use cluster resources and as such if the cluster is removed the instance will not function correctly.

If you like to play with fire in an experimental-not-in-production-learn-by-trial-and-error way, you can do the opposite of How to move SQL Server from Standalone to Cluster environment.

share|improve this answer

Without knowing anything about your cluster I am going to say NO. Since SQL Server was installed as part of the cluster, removing the resource is going remove the clusters knowledge of the SQL Server instance. There will be nothing for users to connect to because an entry path does not exist. Everything will still be there, but waiting in stasis until control is established. The drives and database instance will probably remain on the current node because there will be no voting mechanism to tell them to switch.

What are you trying to accomplish?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.