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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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.
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?