Best practice for setting up SQL server on a Virtual Machine
- by CrazyCoderz
This is my first attempt at virtualizing SQL server on VMWare and I want to make sure I am doing things correctly.
Should I have SQL server installed on the C: drive / same partition as the OS,
Then add a virtual disk for the Data files, say 300GB, and then another virtual disk for the log files say 100GB?
Or should I add 2 300GB vdisks, for the data files mirror them in the operating system, and then add a non mirrored vdisk of 100GB for LogFiles??