SQL Server High Availability

High availability and disaster recovery are key to ensuring reliable business continuity. While SAP workloads are mainly confined to Azure's infrastructure layer, it is still possible to utilize many Azure functions and features to enhance system reliability with relatively little effort. This lesson looks at when, where, and how to use Azure's built-in infrastructure redundancy to improve system resiliency and how various database high availability options are supported.

Learning Objectives

• Understand the key aspects of high availability and disaster recovery
• Learn about availability and availability zones
• Learn about Azure Site Recovery and how to implement it through the Azure portal
• Learn how to set up an internal load balancer in the context of SAP workloads
• Understand the Azure support options for Pacemaker and STONITH
• Learn how to implement Data Guard mirroring via the Azure CLI
• Set up Windows Failover Cluster and SQL Server Always On through the Azure portal

Intended Audience

This lesson is intended for anyone who wants to use Azure's built-in infrastructure redundancy to enhance the reliability and resiliancy of their SAP workloads.

Prerequisites

To get the most out of this lesson, you should be familiar with Azure, Azure CLI, SAP, SQL Server, and STONITH.