Introduction

We are going to setup Always On High Availability so that if one SQL server go down, the application will continue using another SQL server node (server).

For learning you can download Server 2022 and SQL Server 2019 evaluation

However for the production, you need to purchase the following items

• three Windows Server 2022 license
  • One server act as Active Directory (AD)
  • Two servers for SQL Servers node
• Two SQl Server 2019 license
• three server (hardware) as per your workload

In the tutorial, you will see setup-setup guide on how to setup Always On High Availability