Basic Always On Availability Groups in SQL Server Standard


Introduction

In this walkthrough, we will be setting up a Basic Availability Group in SQL Server Standard edition as a base for HA. This is a group of SQL servers that work together to ensure high availability of applications and services. Any HA platform in SQL Server runs in WSFC (albeit for FCI or AG).

Before we get started, here is a list of acronyms used in this document:

Acronym Description WSFC Windows Server Failover Cluster (A group of connected and interdependent servers used for reliability and availability of an environment) HA High