Avatar of Albert Widjaja
Albert Widjaja
Flag for Australia asked on

How to use SQL Server manager to move the Database & Logs to different drive ?

I had this question after viewing Migrating C:\ only in a VM to another VMDK disk ?.

Hi People,

based on the suggestion shared by one of the experts as above thread, how can I use the SQL Server manager to safely migrate the SQL Database and logs from the below Disk 0:
Disk partition layout

Into another newly added drive without causing downtime or database issue on the application setting side ?
[Hopefully I do not have to modify anything from the application perspactive]

Thanks.
StorageDatabasesMicrosoft SQL ServerActive Directory

Avatar of undefined
Last Comment
Albert Widjaja

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Éric Moreau

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.
SOLUTION
andyalder

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.
andyalder

Actually it is probably possible to migrate DISK1 or DISK2 with Storage vMotion, because Windows and SQL wouldn't know it was happening and the drive letters wouldn't change.
Albert Widjaja

ASKER
Andy,

Do you mean clone the VM and then specifying the custom VMDK drive to be cloned ?
and then re-attached the cloned disk to the existing VM ?
andyalder

Not cloning but migrating using svMotion if you have the license for it. svMotion via the GUI moves the whole thing but with the CLI you can move individual disks, https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1004040
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Albert Widjaja

ASKER
Hi Andy,
Yes I do have Enterprise Plus license.

Am I able to svMotion just one VMDK and then resize it on the fly to another VMDK disk ?
Albert Widjaja

ASKER
Thanks all !