Skip Navigation LinksUsing-SQL-Server-2016-AlwaysOn-Availability-Groups-for-SharePoint-On-Premises-and-Azure-SQL-Replicas

Using SQL Server 2016 AlwaysOn Availability Groups for SharePoint On-Premises and Azure SQL Replicas

Michael Noel


Sharepoint PRO

SQL Server 2016 provides for unprecedented high availability and disaster recovery options for SharePoint farms in the form of AlwaysOn Availability Groups. Using this new technology, SharePoint architects can provide for near-instant failover at the data tier, without the risk of any data loss.

In addition, the latest version of this technology, available with SQL Server 2016, allows for replicas of SharePoint databases to be stored in the cloud in Microsoft’s Azure cloud offering. This technology, which will be demonstrated live, completely changes the data tier design options for SharePoint 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 2013 farm, based on the best practices, tips and tricks, and real-world experience of the presenter in deploying this technology in production.

• Understand the differences between SQL AlwaysOn options, and determine the requirements to deploy the technologies
• Examine how SQL Server 2016 AlwaysOn Availability Groups can provide aggressive Service Level Agreements (SLAs) with a Recovery Point Objective (RPO) of zero and a Recovery Time Objective (RTO) of a few seconds.
• See the exact steps required to enable SQL Server 2016 AlwaysOn Availability Groups for a SharePoint On-Premises environment, including options for storing replicas in Microsoft’s Azure cloud service.