On my laptop, I already have the following two virtual machines configured. This article uses the term VirtualBox for subsequent sections. You can browse this URL, and download the platform-specific software, follow the steps and install it. In this article, I use Oracle VM VirtualBox 6.1 version.

It is an open-source virtualization software, and you can install Windows, Linux, Unix operating systems on it. We will use the Oracle VM VirtualBox in this article to create the virtual machines on my laptop. Server 3: It acts as a Secondary node for SQL Server Always On Availability group.Server 2: Primary node in the SQL Server Always On Availability group.Server 1: We require a server for configuring domain controller and active directory.To begin with, we require the following servers. Let’s start the journey toward your first SQL Server Always On Availability group.Ĭonfigure a Virtual Machine in Oracle VirtualBox In this article, we will do the following tasks:Ĭreate Virtual machines with Windows Server 2019 Install SQL Server 2019 on Windows Server 2016 with SQL Server always-on availability groups This series combines the following articles:Ī comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016Ĭonfigure Domain Controller and Active Directory for SQL Server Always On Availability groupsĬonfigure Failover Cluster, Storage controller, and Quorum configurations for SQL Server always-on availability groups You can follow this article series for an end to end guidance on configuration of SQL Server Always On Availability Groups in Windows Server 2016 with SQL Server 2019. Suppose you do not have any infrastructure set up as of now. Still, they are unaware of the underlying infrastructure creation such as virtual machine, configure an active directory, join virtual servers in the domain, configure a failover cluster, quorum configuration, and storage allocation. Usually, Database Administrators are responsible for configuring availability groups in an organization. We can also configure database backups from the secondary instance. It also supports to offload some read workloads to the secondary replica. SQL Server Always On Availability Groups offers high availability and disaster recovery solution for mission-critical databases. We use SQL Server 2019 for configuration. In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016.

How to use virtualbox 2016