How to Migration Windows SQL Cluster with pRDMs in VMware to another VMWare environment

Vinod Kumar Vallur 0 Reputation points
2024-10-24T09:10:08.9133333+00:00

What are the pre-conversion steps to be taken at Microsoft Windows SQL Cluster level before converting the pRDMS into VMDKs in VMWARE

Hi Team,

We have Multiple Windows Two Node Active/Passive Clusters in our VMware vSphere running vSphere 6 and vSphere 7 environment.

The clusters are built with pRDMS as the shared disk. We are planning to migrate these Cluster Servers to new Server hardware with vSphere environment deployed.

The strategy we are following is:

  1. Break the Windows SQL Cluster and run all the SQL Cluster services from one Active Node.
  2. Convert the pRDMS into VMDKs using the storage vMotion.

We have ran the above two steps and after converting the pRDMS into VMDKs the cluster disks are failing and not coming online and also the disks at computer management too are not coming online.

Please let me know do we need to run any pre-migration tasks with respect to windows and sql cluster services before running the conversion of pRDMS into vRDMS?

Windows for business | Windows Server | User experience | Other
SQL Server | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Alex Bykovskyi 2,241 Reputation points
    2024-10-24T12:34:46.37+00:00

    Hey,

    The issue might be related to the cluster reservation, which can be cleared. https://learn.microsoft.com/en-us/troubleshoot/windows-server/high-availability/troubleshoot-cannot-bring-physical-disk-online

    You can use the following command to clear reservation and bring disk online in disk management.

    Clear-ClusterDiskReservation
    

    https://learn.microsoft.com/en-us/powershell/module/failoverclusters/clear-clusterdiskreservation?view=windowsserver2022-ps

    As for pRDM conversion, you can also use StarWind V2V converter to convert pRDM to VMDK.
    https://www.starwindsoftware.com/starwind-v2v-converter

    Cheers,

    Alex Bykovskyi

    StarWind Software

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    0 comments No comments

  2. LiHongMSFT-4306 31,566 Reputation points
    2024-10-25T07:07:34.56+00:00

    Hi @Vinod Kumar Vallur

    Please let me know do we need to run any pre-migration tasks with respect to windows and sql cluster services before running the conversion of pRDMS into vRDMS?

    You need make sure that the Windows and SQL Server versions in the target environment are compatible with the configurations of pRDMS.

    Also, you need to check the storage configuration and connections to ensure the new VMDK can be recognized and accessed properly.

    Best regards,

    Cosmog


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.