Microsoft SQL Always On Availability Group is effectively a SQL mirroring cluster.
| Include Page | ||||
|---|---|---|---|---|
|
In a Microsoft SQL Always On Availability Group, there is one single primary replica, aka, the active database, and up to 8 secondary replicas, aka, the passive databases.
Setting up a HA cluster with a Microsoft SQL Always-on Availability Group is very simple. Follow the steps below:
Set up a Microsoft SQL Always On Availability Group
We assume that you already have a Microsoft SQL Always On Availability Group in your organization. Otherwise, please follow the article below.
Step-By-Step: Creating a SQL Server Always On Availability Group
Install the Primary DualShield Server
Follow the normal installation process to install the primary DualShield Server. In the database selection step, select Microsoft SQL as the database server
| Expand | ||||||
|---|---|---|---|---|---|---|
|
Install the Secondary DualShield Server
The secondary DualShield server must be a replica of the primary DualShield server. Follow the guide below to clone the primary DualShield server to the secondary server machine.
| Expand | ||||||
|---|---|---|---|---|---|---|
|