So I have successfully set up a 2 node 2008 R2 cluster with SQL Server 2008.
There are basically 3 networks.
- Public (client LAN)
- Private (Heartbeat between the two machines)
- iSCSI SAN (hosts witness disk and SQL storage)
I have had the cluster successfully failover by disconnecting the public network, by manually transferring the service, and by rebooting one of the machines.
What I cant get get to failover is when I pull the iSCSI network connection from the hosting machine. The service falls flat on its face and doesn't recover until I plug back in and manually bring the service online.
My quorum mode is
Node and Disk Majority.
My understanding is that if Machine 1 loses its connection to either the public network or the iSCSI resource, that the whole cluster should failover to Machine 2 which still has an established connection to both networks.