lstanke
asked on
Move a disk resource in a sql cluster
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?
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?
Member_2_3654191
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.
ASKER
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.
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.
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:
http://technet2.microsoft.com/windowsserver/en/library/1c5c3a6c-b64c-4e47-9c06-2735809b76b91033.mspx?mfr=true
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:
http://technet2.microsoft.com/windowsserver/en/library/1c5c3a6c-b64c-4e47-9c06-2735809b76b91033.mspx?mfr=true
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.