SharePoint Infrastructure Management and Administration, For Database Administrators, For IT Professionals

SPT09 Using SQL Server 2012 AlwaysOn Availability Groups for SharePoint Farms


4:15 PM - 5:30 PM

Level: Intermediate to Advanced

Michael Noel

Michael Noel


Convergent Computing

The release of SQL Server 2012 provides for unprecedented high availability and disaster recovery options for SharePoint farms in the form of AlwaysOn Availability Groups, the newest form of Database Mirroring. Using this new technology, SharePoint architects can provide for near-instant failover at the data tier, without the risk of any data loss. This technology, which will be demonstrated live, completely changes the data tier design options for SharePoint 2010 and SharePoint 2013 farms and revolutionizes high availability options for a farm. This session covers in step by step detail the exact configuration required to enable this functionality for a SharePoint 2010 or SharePoint 2013 farm, based on the Best Practices, tips and tricks, and real-world experience of the presenter in deploying this technology in production.

You will learn:

  • Understand how SQL 2012 AlwaysOn Availability Groups changes the data tier design options for SharePoint 2010 and how they can be used to significantly improve the high availability and disaster tolerance of a farm.
  • Determine the difference between SQL 2012 AlwaysOn Availability Group options and what makes sense for various SharePoint farm scenarios, including remote DR and remote read-only farm options.
  • Be able to immediately use the information included in the session to setup SQL 2012 AlwaysOn Availability Groups for a SharePoint environment based on the best practices and step-by-step guidance provided.