Introducing SQL Server AlwaysOn

SQL Server AlwaysOn is the new comprehensive high availability and disaster recovery solution in SQL Server 2012. Using AlwaysOn, you can increase application availability and get a better return on your hardware investments through a simplified high availability (HA) deployment and management experience.

See: FAQ | Features in SQL Server 2012

Getting Started

SQL Server AlwaysOn provides availability at either the application database or instance level. Learn more about how to use AlwaysOn to maintain availability at each of these levels.

Database Availability

AlwaysOn Availability Group provides high availability and disaster recover for application databases.
Learn more...

Key Capabilities and Concepts

Step-by-Step Guide

Instance Availability

AlwaysOn Failover Cluster Instance enhances the existing failover clustering instance and now provides high availability and disaster recovery for SQL Server Instances.
Learn more...

Key Capabilities and Concepts

Introducing Flexible Failover Policy for Cluster Health Detection

Step-by-Step Guide

Note: The links in this section correspond to the AlwaysOn features found in SQL Server 2012.

Additional Resources

AlwaysOn Team Blog

SQL Server 2012 AlwaysOn

NOW AVAILABLE: Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments
Monday, Apr 9 Sanjay Mishra
Concurrent ADD NODE operation yields unexpected results in a SQL Server Failover Cluster Instance
Friday, Mar 30 Sanjay Mishra
DO NOT use Windows Failover Cluster Manager to perform Availability Group Failover
Friday, Mar 30 Sanjay Mishra
Quorum vote configuration check in AlwaysOn Availability Group Wizards (Andy Jing)
Tuesday, Mar 13 Qiang Wang

More...

High Availability and Disaster Recovery Forum

SQL Server 2012 AlwaysOn

Failover Clustering with NAS/SMB shares Demo
Wednesday, May 18
Cross Instance VSS Restore
Tuesday, Feb 21
Reporting Services and ApplicationIntent connection string property
Tuesday, Aug 16
AlwaysOn on Virtual m/c
Tuesday, Feb 7
AlwaysOn Readable Mirror
Saturday, Nov 13
Required 9’s
Wednesday, Mar 7

Go to forum...

Follow Us:

SQL Server 2012 Feedback

File bugs for SQL Server 2012
Take this short survey on the changes to SQL Server product documentation.

To submit feedback, sign into Connect with your Windows Live ID.

SQL Server 2012 Links

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?

Privacy Statement