This article is part of an Essential Guide, our editor-selected collection of our best articles, videos and other content on this topic. Explore more in this guide:
4. - Glossary of terms related to SQL Server upgrades: Read more in this section
Explore other sections in this guide:
- 1. - What's new in SQL Server 2014
- 2. - A closer look at in-memory processing in SQL 2014
- 3. - Commentary on SQL Server releases
AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together.
Traditional database mirroring in SQL Server was only for a single database. AlwaysOn Availability Groups are designed to be used for multiple databases, which allows for improved cross-database referencing during failover. Another benefit is that generating multiple replicas of an availability group allows an administrator to make one of them read-only, for example if they want a group of databases for reporting purposes only.
An AlwaysOn Availability Group supports a set of primary databases as well as multiple sets of secondary databases (up to four in SQL Server 2012, and eight in SQL Server 2014). An administrator can configure an availability group to replicate synchronously for high availability or asynchronously for disaster recovery (DR).