• Bobby Glover (6/14/2013)


    Thanks, does this apply to when the Primary db falls offline too.

    Lets say san administrator removed the disks that held the mdf and Ldf files. This would also force the sec, offline.

    If this is the case that is very poor.

    If set to "automatic failover", synchronous commit, it should fail over to the secondary provided a quorum exists. You should consider created a file share witness for a two node cluster in order to retain a quorum.

    If you don't have a quorum, then it will go "offline" which is how a physical cluster also works. A physical cluster goes "offline" when the quorum is lost.

    Here are some MS articles regarding file share witness and HA.

    http://blogs.technet.com/b/askpfeplat/archive/2012/06/27/clustering-what-exactly-is-a-file-share-witness-and-when-should-i-use-one.aspx

    http://technet.microsoft.com/en-us/library/cc770620(v=ws.10).aspx

    Steve