PHXHoward (4/3/2014)
I'm looking for a solution to have cross data center automatic failover in the event of a data center loss for highly critical databases. I would like to have local HA and also automatic failover to the DR site. This does not seem possible with AlwaysOn.
To have local HA at the instance level would require a clustered instance, this may only participate in an AO group for manual failover. Given this, it doesn't meet your requirement.
PHXHoward (4/3/2014)
Is my only option for automatic cross data center failover to build a node in one data center and a node in the other data center with a node/FS at a third data center in order to maintain quorum? I'd like to have local HA in the mix but that doesn't seem possible.What pattern do you suggest for the highest data security and also availability?
Thanks
You may still achieve local HA using alwaysOn by having a secondary replica on the primary site configured for automatic failover.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉