AlwaysOn Availability Groups

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).

Contributor(s): Mark Fontecchio
This was last updated in January 2014
Posted by: Margaret Rouse
View the next item in this Essential Guide: SQL Server buffer pool or view the full guide: SQL 2014: Investigating Microsoft's latest database release

More News and Tutorials

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Research More Tech Terms

  • Search thousands of tech definitions
  • Browse tech definitions
    Browse Alphabetically:

Powered by WhatIs.com

File Extensions and File Formats

File Extension and File Formats List:

Powered by WhatIs.com