Lesson 4

AlwaysOn Availability Groups

Learning Objectives

By the end of this lesson, you will be able to do the following:

  • Describe AlwaysOn availability groups and terminology
  • Explain data synchronization in AlwaysOn
  • Configure Active Directory Domain Controller
  • Configure Windows Server Failover Cluster
  • Configure AlwaysOn availability groups using SQL Server Management Studio
  • Configure AlwaysOn availability groups on Microsoft Azure

This lesson will teach us how to configure an AlwaysOn availability group using various methods.


This lesson introduces SQL Server AlwaysOn availability groups (AGs) and talks about related concepts and terminology. This lesson also talks about the common AlwaysOn topologies, use cases, and the ...

Get Professional SQL Server High Availability and Disaster Recovery now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.