Lesson 5

Managing AlwaysOn Availability Groups

Learning Objectives

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

  • Perform automatic and manual failover
  • Perform various management tasks against an availability group
  • Monitor an AlwaysOn availability group
  • Detect common AlwaysOn availability group problems and implement their solutions

This lesson will show us how to manage and maintain an AlwaysOn AG. We will also learn how to troubleshoot an AG.

Introduction

In the previous lesson, we configured a three-node AlwaysOn availability group (AG) with one primary and two secondary nodes.

However, configuring an AlwaysOn AG is half the task. In this lesson, we'll learn to manage and maintain AlwaysOn availability groups. We'll ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.