SQL Server 2012 AlwaysOn FAQs

  • Article

Krishna Golla has a grab-bag of SQL Server 2012 AlwaysOn FAQs suitable for DBAs and Infrastructure types, covering everything from the hotfixes recommended for AlwaysOn, to whether Availability Groups can be defined outside a domain boundary.

For example, in the Failover Scenarios section:

1. What happens when your primary replica is offline? Which replica does your AG failover to? AG fails over to the replica which has been configured for Automatic failover partner. If there are no automatic failover partners AG doesn’t failover automatically
2. What happens when the original primary replica comes back again? When the original primary comes back online, it will assume the role of a secondary and starts syncing pages with the current Primary.

… and many, many more.

It’s an easy read, and consolidates lots of gotchas into the one document. Thanks Krishna!

Posted by Tristan Kington , MSPFE Editor and I did a Dachsund joke already, right? What about a Datsun joke?