Avatar of Albert Widjaja
Albert Widjaja
Flag for Australia asked on

Migrating C:\ only in a VM to another VMDK disk ?

Hi All,

I've got one Big SQL Server production VM that was deployed incorrectly by the contractor with 4x drive like below:

Big VM
My question is:

1. How to detach or migrate the C:\ drive only to separate VMDK drive, so I can maximize the Disk 0 capacity ?
2. Is it possible to start the VM with no impact to the SQL Server functionality after the C:\ partition migration to dedicated VMDK as the new C:\ drive with no drive letter change ?

How can I achieve this ?

Thanks
VirtualizationStorageMicrosoft SQL ServerVMware

Avatar of undefined
Last Comment
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

8/22/2022 - Mon
SOLUTION
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Albert Widjaja

ASKER
Hi Andrew,

So how do I do that ?
is it using Vmware converter ? what's the high level steps
SOLUTION
David Johnson, CD

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

No it's not using VMware Converter.

Depends what data you have on those drives, and you may need to use SQL Manager to move the Logs and Databases.
Albert Widjaja

ASKER
Thanks all for the suggestion.

Can I use VMware converter to do something?
I've just realized that Disk 1, 2 and 3 is iSCSI LUN that is presented only to this VM by using the Windows built-in iSCSI initiator to the NAS.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

Yes, VMware Converter will convert to a VMDK.

but I thought this was a question about C: drive ?
Albert Widjaja

ASKER
Yes, the question is on the C: drive.

I assume if I create it as VMDK, would it be possible that the Disk 0 drive E:\ and D:\ is closed to separate disk like Disk 4 drive E:\ and D:\ in the new VM ?
and then after that, I can just delete the Disk 0 drive E:\ and D:\ followed by running the SQL server services again ?
ASKER CERTIFIED SOLUTION
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.