From the course: SQL Server 2016: Administer a Database Infrastructure

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create distributed availability groups

Create distributed availability groups - SQL Server Tutorial

From the course: SQL Server 2016: Administer a Database Infrastructure

Start my 1-month free trial

Create distributed availability groups

“

- [Instructor] In SQL Server 2016, availability groups gained the ability to be spread out over very large distances. With distributed availability groups, the setup starts with two independent Windows Server Failover Clusters. These two clusters can be many miles apart as is typical in a disaster recovery model. By having the primary cluster geographically separate from the disaster recovery or the DR cluster, you mitigate the potential for both clusters to get physically caught in the same catastrophic event. On each of these clusters is its own availability group. Each having their own primary and secondary replica databases. These availability groups get associated with each other, in effect, creating an availability group of availability groups. When this happens, one availability group gets designated as the primary. All updates are made to the primary replica, on the primary availability group. This replica will update the secondary replicas within its group and also send…

Contents