Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
did this pass the cluster validation test? –  tony roth Mar 26 '12 at 20:57
    
yes. and all services failover and failback properly if I do it manually through the management console –  Brian Mar 26 '12 at 21:48
    
I had a similar issue with a cheap iscsi device it didn't really support persistent reservations wonder if thats an issue here. –  tony roth Mar 27 '12 at 20:27
    
While we didnt go for a very expensive HP or Dell iSCSI solution, this isnt exactly a cheap unit either. Its made by QNAP. According to their site it supports SPC-3 Persistent Reservation QNAP Software Spec –  Brian Mar 27 '12 at 20:36
    
qnap was the device that I used and it was not compliant with spc-3 at the time. But from what I've read that currently should be a non issue. When you did cluster validation test did you skip storage? –  tony roth Mar 27 '12 at 21:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.