terça-feira, junho 22, 2021

SQL 2019 - Always on Step by Step

 Domain: maykonrds.site

SQL Server 01: sql1

SQL Server 02: sql2

On your domain controller create an object account and disable, I created SQLCluster computer object:

 

Give them permission to the user who will create the Cluster, in my case is maykonsql.

 

Install the failover cluster on both servers (sql1 and sql2), on powershell:

>Install-WindowsFeature -Name Failover-Clustering -IncludeManagementTools 

Open the cluster and do a validation:

 

 

After validation create the cluster:

 

The cluster name needs to be the object that you created on your Active Directory.

 

 Install SQL Server on SQL1 and SQL2 (Standalone Installation).

After that Enable the Always on SQL Configuration Manager - SQL Server Services - Check Enable Always on Availability Groups for sql1 and sql2:

 

 Go to SQL Always On High Availability - New Availability Group Wizard:

 

Type a name:

 Add your database:

 

Add a replica (sql2):

 

 Select the synchronization preference:

 

 


Add a listerner (You can create a listerner on the Wizard as well).


Nenhum comentário: