What are your thoughts about:
- SQL cluster (2005 or greater) built on two Hyper-V nodes, Win 2008R2
- The nodes are on separate Hyper-V hosts
- Each host is itself running on a hardware-based Win 2008R2 cluster
We have several of these in SQL 2008R2 and a couple in SQL 2005.
Is there any real advantage to this belts-and-suspenders approach?
Is there any specific danger or vulnerability (i.e., might a failure at the hardware level cause simultaneous failovers, and what might be the implications there?
I'd appreciate your insights.
DBA, 1st Source Bank
Senior Database Administrator
1st Source Bank