Best practice for setting up SQL server on a Virtual Machine

Posted by CrazyCoderz on Server Fault See other posts from Server Fault or by CrazyCoderz
Published on 2012-12-10T00:57:38Z Indexed on 2012/12/10 5:08 UTC
Read the original article Hit count: 405

Filed under:
|

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??

© Server Fault or respective owner

Related posts about Windows

Related posts about sql-server-2008