Link to home
Start Free TrialLog in
Avatar of Albert Widjaja
Albert WidjajaFlag 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.
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Member_2_231077
Member_2_231077

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.
Avatar of 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 ?
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
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 ?
Thanks all !