SQL Cluster install on Hyper V options

Posted by Chris W on Server Fault See other posts from Server Fault or by Chris W
Published on 2010-03-26T11:44:46Z Indexed on 2010/03/26 11:53 UTC
Read the original article Hit count: 177

I've been reading up on running a SQL Cluster in a Hyper V environment and there seems to be a couple of options:

  1. Install guest cluster on 2 VMs that are themselves part of a fail over cluster.

  2. Install SQL cluster on 2 VMs but the VMs themselves are not part of an underlying cluster.

With option 1, it's little more complex as there's effectively two clusters in play but this adds some flexibility in the sense that I'm free to migrate the VMs between and physical blades in their cluster for physical maintenance without affecting the status of the SQL guest cluster that's running within them.

With option 2, the set-up is a bit simpler as there's only 1 cluster in the mix but my VMs are anchored to the physical blades that they're set-up on (I'll ignore the fact I could manually move the VHDs for the purposes of this question).

Are there any other factors that I should consider here when deciding which option to go for?

I'm free to test out both options and probably will do but if any one has working experience of these set-ups and can offer some input that would be great.

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about hyper-v