Deploy a distributed SQL Server Always On Availability Group

In the previous article, An overview of distributed SQL Server Always On Availability Groups, we explored the concept of the distributed availability groups in SQL Server always on availability group. It is available from Windows Server 2016 and SQL Server 2017.

An overview of distributed SQL Server Always On Availability Groups

SQL Server 2016 provides a new feature Distributed Availability Group for disaster recovery purposes. It is a particular type of availability group that helps access the multiple failover clusters. In this article’s series, we configured a traditional Always On group. It has the following requirements.

Configure Managed Service Accounts for SQL Server Always On Availability Groups

This article gives an overview of Configuring Managed Service Accounts for SQL Server Always On Availability Groups.

Add a new node into existing SQL Server Always On Availability Groups

This article gives an overview of adding a new node into existing SQL Server Always On Availability Groups. In the previous articles (see TOC at the bottom), we configured a two-node SQL Server Always On Availability Group.

Automatic Page Repair in SQL Server Always On Availability Groups

This article gives an overview of Automatic Page Repair in SQL Server Always On Availability Groups. SQL Server Always On is a disaster and high availability feature. In the previous articles, we explored the following features.

Configuring SQL Server Always On Availability Groups on AWS EC2

This article will provide a review on how to configure Always On Availability groups in AWS EC2 instances and AWS FSx as file share witness.

Deploy a domain-independent Windows Failover Cluster for SQL Server

This article shows how to deploy a domain-independent Windows Failover Cluster for SQL Server Always On Availability Groups. In this series, we configured the SQL Server Always On Availability Groups beginning from virtual server build. Always On provides a robust high availability and disaster recovery solution in SQL Server.

SQL Server Always On Availability Group on the domain-independent Failover Cluster

This article configures SQL Server Always On Availability Groups on the domain independent Windows Failover Clusters. In the previous article, Deploy a domain-independent Windows Failover Cluster for SQL Server Always On Availability Groups, we learned the new capability in Windows Server 2016 to configure a domain-independent Windows failover cluster.

Database-level health detection in SQL Server Always On Availability Groups

This article gives an overview of SQL Server Always On Availability Group features. SQL Server Always On Availability Groups create a group of databases that fails over together in case the primary replica is unavailable.

Install SQL Server 2019 on Windows Server 2016 with SQL Server

In this article, we will discuss configuring SQL Server Always On Availability Groups and perform failover validations. You should go through the following articles and build the infrastructure before proceeding with this article.

Add or remove a node from SQL Server Always On Availability Groups using T-SQL scripts

This article gives an overview of SQL Server Always On Availability Group features. We configured the SQL Server Always On Availability Group from the beginning of building virtual machines.