[Webinar] Learn how to a build a cloud-first strategyRegister Now


Move a disk resource in a sql cluster

Posted on 2007-07-27
Medium Priority
Last Modified: 2010-09-21
I have a 3+1 SQL 2005 cluster .  I need to move an existing disk resource (LUN) from one sql virtual server to another.  I removed the drive as a dependency of any other resource and now am prepared to move it.

When I try to move the resource to another virtual server (group). I get an error saying that : The Cluster Node is not the owner of the group. Error id: 5016

I have read that the node on which the SQL Virtual Server was created must own this group.  I am not sure exactly what this means.

How do I determine the owner ship that is being referenced here so I can move this resource?
Question by:lstanke
  • 3
  • 2
LVL 16

Expert Comment

ID: 19583795
The owner is actually the node where the disk resource is active on. So if you are connected to server2 then first move the resource over to that node or connect to the other node first where the disk resource is running.

Author Comment

ID: 19584891
Either I am not understanding or this isnt my issue.  
I have 4 nodes: 2A,2B,2C,2D
I have 3 virtual servers: V1,V2,V3
The disk I want to move is on V2 and currently all resources are running on 2B.  
I want to move the G drive on V2 to V3 (which is running on 2C).  

When I try to drag and drop or use the Change Group menu, I get the message The Cluster Node is not the owner of the group.  In case it made a difference, I have tried this from 2B and V2 with the same results.

LVL 16

Expert Comment

ID: 19587410
Well, yes I thought that was the difference but obviously it's not.

So I think that the node where you want the disk resource to be moved to is simply not in the list of possible owners for that disk resource.

Have a look at this. It should solve your problem:


Author Comment

ID: 19587992
All nodes are possible owners for this resource.
I think it has something to do with this:
Note:  The node on which the SQL Virtual Server was created must own this group. If this is not the case, first move the group to this node. The group can be moved back to the original node after the move.

If you didnt create the cluster how would you know which node it was created on?

Seems like it might be easier to simply delete the resource and add it to the correct virtual server.
LVL 16

Accepted Solution

The_Kirschi earned 750 total points
ID: 19588024
Ok, I found another one. It seems that both of the groups - the one where the disk resource is currently located and the one where you want it to be - need to be running on the same node:


Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Loops Section Overview
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question