SQL 2008 Failover Cluster on Hyper-V Cluster

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi all! I am designing a virtualized "Always On" solution for a client using SQL2k8 (Edition TBD) + Win2k8 Hyper-V.

I will have 8 boxes conforming a Windows 2008 Cluster where my VMs will be hosted as a High Available service featuring Quick Migration. Now I need to know how to provide HA to my virtulized SQL Server Service.

Is there any recommended reading regarding this? I have read many about SQL virtualization but nothing about a HA environment.

My approach would be:
- Create 2 SQL VMs (SQL1, SQL2) hosted on different boxes (Host1, Host2).
- Host1 and Host2 are members of my Win2k8 Cluster
- Create a Fail-over cluster between SQL1 (active node) and SQL2.

Disaster
- SQL1 fails -> SQL Fail-over cluster moves control to the passive node until recovery.
- Host1 fails -> Win2k8 Fail-over starts the VM on a Host3 and while Quick migration takes place SQL Fail-over cluster moves control to the passive node

How does it sound?
Any guidance will be appreciated,
Thanks a lot,
Beto.


.