Azure SQL VM - Implementing Basic AG in SQL 2016 STD

Speaker(s)Kenneth Urena

Duration: 60 minutes

Track: Build

For a long time Database Professionals have been asking Microsoft to make Always on Availability Groups (AG) available in Standard Edition. With SQL Server 2016 SP1, Microsoft responded with Basic Availability Groups, a limited but very functional version of Always on Availability Groups.

Basic Availability Groups enable Data Professionals to provide enterprise class High Availability solutions using SQL Server Standard Edition, which allows organizations to save money by providing High Availability (HA) for applications that require HA without paying for SQL Server Enterprise Edition features they do not need.

In this session, we will be covering:
- Limitations on Basic Availability Groups
- Components and steps necessary to configure a Basic AG for an Azure Virtual Machine (VM) running SQL Server 2016

Accompanying Materials:

No material found.