Last night I was at the Ottawa SQL Group event helping out and I found out an interesting tidbit. This tidbit is only for production environments only, in Dev or in test labs, anything goes.

SQL 2000 are NOT supported under at virtualization product!

Now some people are going to asked about SQL 2005 & 2008, yes it is supported HOWEVER there is only one supported configuration (for MS Virtualization technologies, we didn’t talk about VMware so that one is still within “grey” area)

SQL 2005 & 2008 is only supported on Hyper-v!

SQL 2005 & 2008 is only supported if you used pass through disks!


Having said this people are going to ask for supporting docs, where here are a few:


SQL 2008


Running SQL Server 2008 in a Hyper-V Environment – Best Practices and Performance Considerations


Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment