Setting Up SQL Server AlwaysOn Availability Group
On this part I'm going to show a demo on how to set up SQL Server AlwaysOn Availability Group on local computer. First, we need to have virtual machines on our local computer because we need to spawn at least 3 VM servers that will be domain controller, SQL Server 1 (primary), and SQL Server 2 (secondary) To do that, you need to install VMWare Workstation first (or any other tools for virtual machine), it can be downloaded for free from: VMWare Also you need to have Windows iso, SQL Server iso, and SSMS installer. What I use: Windows Server 2019 evaluation edition from Microsoft: Windows Server 2019 ISO SQL Server 2019 Developer Edition: SQL Server Developer Edition Downloads (this, you need to login first because official SQL Server Developer Edition now can only be downloaded from Visual Studio website) SQL Server Management Studio: SSMS Notes: if you are planning to use SQL Server 2012 or earlier, you need to download .NET Framework 3.5 installer too because Windows Server