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. It's 100% free, no registration required.

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

In the process of removing an usused disk resource from cluster, I would follow these steps: 1) remove dependencies on the disks by the SQL Server resource, 2) take the disk resource offline, 3) delete the disk resource from the SQL resource group, 4) delete the disk resource from the Available storage pool.

I was proceeding to do this on a two node cluster with two SQL 2008 R2 named instances (running Win2K8R2 SP1 build 6701, 64-bit). On deleting a resource in step 3 above, SQL would go offline, all the disk resources would go back to the Available pool, and the SQL resources (Net Name, SQL Server, SQL Server Agent) would disappear. SQL services do restart OK after via the services console as all the disks are still on the same node.

I ran cluster res from the command prompt and I see the SQL service resources are still there, in Available Storage, and offline.

To bring the resources back to the appropriate group, can I move them via cluster commands?

share|improve this question
Did you ever resolve this? I have almost the same thing. Went to remove a disk from a cluster SQL Server service - and for some reason all disks now show under available storage. The SQL Server service shows no resources. The SQL Server is still up and running. I'm almost afraid to do anything - including run cluster /res... Don't want to lose this production server. – user2280539 Jan 15 '14 at 22:55

The link below has the likely answer. Premier Support agrees that the steps to fix should fix my similar issue. I plan on going through the steps during my next outage window.

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.