Carlton Leach (5/21/2014)
does it allow you to:- create a 2 node cluster, 2 Standalone instance, with no shared disk?
Yes that's pretty much a basic configuration with an AlwaysOn group across 2 replicas
Carlton Leach (5/21/2014)
If so, in the above scenario:- If primary fails, same as DB mirroring: force online with data-loss accepted
If you don't have synchronous with auto failover then yes.
Carlton Leach (5/21/2014)
- If secondary instance fails, does that still wipe out the AWO group? (on node majority).Carlton.
not if you configure a cluster witness appropriately
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉