Skip to Main Content
Professional SQL Server High Availability and Disaster Recovery
book

Professional SQL Server High Availability and Disaster Recovery

by Ahmad Osama
January 2019
Intermediate to advanced content levelIntermediate to advanced
564 pages
9h 2m
English
Packt Publishing
Content preview from Professional SQL Server High Availability and Disaster Recovery

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional SQL Server 2012 Internals and Troubleshooting

Professional SQL Server 2012 Internals and Troubleshooting

Christian Bolton, James Rowland-Jones, Glenn Berry, Justin Langford, Gavin Payne, Amit Banerjee

Publisher Resources

ISBN: 9781789802597Supplemental Content