Practice SQL Server AlwaysOn Setup & Configuration. From building virtual machines, Installing OS & SQL Server, Setup Cluster to the actual Setup of AlwaysOn AG features.
Step by Step procedure to create SQL Server AlwaysOn Availability Group. Starting from building virtual machines virtual machines, Installing OS & SQL Server, Setup Cluster to the actual Setup of AlwaysOn AG features.
B1. Hyper-V features installed or VMware Player or Workstation. I'll be using Hyper-V. To install Hyper-V features, go to Install Hyper-V on Windows 10.
B2. SQL Server Installer. I'll be using SQL Server Developer Edition here. To download, go to "SQL Server on-premises".
B3. SQL Server Management Studio (SSMS). To download, go to, Download SQL Server Management Studio (SSMS).
I. Create virtual machines using Hyper-V
II. Install OS and OS features such as Active Directory Domain Services
III. Join MS SQL Database Server to Domain & Create a Windows Failover Cluster
IV. Install & Configure SQL Server & SSMS on both SQL Server Nodes
V. Add a sample database and Setup AlwaysON AG features
VI. Create or Restore databases & Add DB to Availability Group
Whenever you go the stages, always switch to "main" branch.
