Shulou(Shulou.com)06/02 Report--

No more nonsense, go straight to the topic, how to configure alwayson

After SQL is installed on two SQL Server servers, open any SQL service manager, select the SQL Server (MSSQLSERVER) property-select alwayson high availability, fill in the FQDN of the Windows failover cluster, and check enable alwayson high availability group.

Restart the SQL service when prompted

After the service restart is completed, open the SQL Server management console, right-click the server properties, and check whether the enabled HADR is true.

After you have done the above, go to the second SQL Server server and do the same to enable the Alwayson high availability group

Since SQL Alwayson is a high availability group for the database, there must be a SQL database at this time, which is mentioned before when deploying ADFS. First, fill in a SQL Server FQDN in ADFS and let the system automatically create the database, and then we will configure the database with high availability group.

When we create the service farm on our first ADFS server (the specified SQL is 01) and return to sql01 to open the database management console, we can see that the corresponding database has been created automatically

Next, make a full backup of the two ADFS databases (alwayson cannot be configured without a full backup)

Select backup path

Complete the backup

Pay attention to the shared configuration of the backed up folder

Also make a full backup of another database

Create an alwayson high availability group after completing the backup

Fill in the alwayson group name

Check the database that has been backed up two times before.

Choose to add a copy

Select the SQL02 server in the pop-up window

After the addition is completed, configure as follows

Select the initially synchronized data to be obtained from the previously backed up folder

Verify that a high availability group can be created

Click next to complete the creation of the high availability group

After you have created an alwayson high availability group, you need to create a listener, right-click to select the availability group listener, and select create

Enter the FQDN of the listener, port 1433, and add the IP of the listener

Click OK to finish adding the listener

Go back to the Windows failover cluster to check if the alwayson high availability group listener was created successfully

Go to the sql02 server and open the sql server management console to check whether the database is synchronized

At this point, I have completed the implementation of the whole SQL Alwayson. I hope it will be helpful to all of you.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.