SQL Server 2016: Availability Groups replay

Subject: SQL Server 2016 Availability Groups
For: DBAs, developers, IT management, system engineers, …

  • AlwaysOn Basic Availability Groups
  • Standard vs enterprise edition
  • Latest features
  • Limitations

AlwaysOn, always available
In SQL Server 2012, the AlwaysOn Basic Availability Groups was a feature that was only accessible in the Enterprise Edition. In SQL Server 2016, however, you can also configure and manage one or more availability groups in the Standard Edition, allowing you to supports a failover environment for a single database. Both editions are much alike, but there are some limitations for basic availability groups in the Standard edition. For instance, there is a limit of two replicas (primary and secondary), there is no read access or backs on the secondary replica, etc. During our webinar replay we discuss these restrictions and, if possible, how to circumnavigate them.

Getting started
So you have the AlwaysOn Basic Availability Groups at your disposal, but how do you get started? With tips and tricks, we‘ll demonstrate how you create Groups on any two SQL Server 2016 Standard Edition servers, since there is no user interface support in SQL Server Management Studio yet.

Webinar hosted by
Frederik Bogaerts

Join Frederik Bogaerts

I want to watch the replay

Get the best tips and tricks about SQL Server 2016 availibility groups