Move a disk resource in a sql cluster

Posted on 2007-07-27
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
    LVL 16

    Expert Comment

    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

    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

    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

    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

    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

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now