Moving a SQL Virtual Cluster to another resource group fails

Mike Crowley 126 Reputation points
2022-04-26T14:01:53.74+00:00

I am attempting to move an Azure SQL virtual cluster (microsoft.sql/virtualclusters) to another resource group within the same subscription. The pre-move validation succeeds however the move ultimately fails. This is supporting a Managed Instance. Is there something I need to do to SQL MI before the move? If not, what is the best way to get this resource into the desired RG? The statusCode is "conflict" but am not sure what that means.

196634-screenshot-2022-04-26-095702.png

        "statusCode": "Conflict",  
        "statusMessage": "{\"error\":{\"code\":\"ResourceMoveFailed\",\"message\":\"
Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
    2022-04-26T16:36:22.347+00:00

    Hi, @Mike Crowley Thanks for the question and for using the MS Q&A platform sorry for the inconvenience caused.
    As we understand the ask here is you want to know why the failure occurred while moving the Azure SQL virtual cluster to another resource group within the same subscription.

    Unfortunately, this is not supported, Internal product team is working on the set of improvements for the virtual cluster and this is part of the scope, however, the expected timeframe is Q3 this CY.
    A virtual cluster always ends up in the same resource group as the virtual network used for instance deployment, depending on the organization of the resources on your side, you would have either to re-create the resources or eventually move the instances to another subnet which is in another resource group.
    please refer to this document for more information.

    Can you please tell me what are you trying to achieve? Move the entire environment to another resource group or move only the virtual cluster?

    Please let me know if you need any additional information.

    Regards
    Geetha

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Mike Crowley 126 Reputation points
    2022-04-26T19:50:27.88+00:00

    Thanks for your reply. I wonder what the purpose of the 5-minute pre-move validation is, if not to determine if the resource is supported for the move.

    As for the ultimate purpose, Resource Groups are best used as boundaries for resources that share the same lifecycle. We deployed a SQL MI to support a datawarehouse effort, however it sits on an already established VNET, which is used for other services as well. For delegation of management, cost reporting and overall resource management, I wanted to put the SQL virtual cluster in the same RG as the Managed Instance (and other datawarehouse components).

    But either way, I appreciate the clear answer.

    Follow-up question: Are we charged for the virtual cluster itself, or just all of the other components (MI, database, storage, etc.)? If its a free resource my situation is less of a concern.


  2. Roger Bossard 51 Reputation points
    2023-06-27T09:00:50.2833333+00:00

    Hello [Mike Crowley],
    have you been able to [Move] the VirtualCluster to another RG in the mean time ?
    I have the same Problem now. The VC was built in the NetworkRG but I want it in den SQLMI-RG if this is now possible.

    Have you done this successfully yet ?

    Regards from Switzerland - Roger

    0 comments No comments