From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Work with Always On Availability Groups

Work with Always On Availability Groups - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Work with Always On Availability Groups

“

- [Narrator] Sequel Server supports another high availability option that runs on top of Windows Server Failover Clusters and it's called Always On Availability Groups. Let's start by talking about what a Failover Cluster is. The Windows Server operating system supports an installation mode called Failover Clustering. In this configuration, multiple physical servers get lumped together into a single cluster, which to the wider network, appears as a single machine. Each server in the cluster is called a node and together, the nodes share responsibilities for managing the resources of the cluster. Sequel Server Availability Groups take a different approach to leveraging the Failover Cluster technology than Always On Failover Clusters in a few ways. First, with availability groups, each node in the cluster gets it's own standalone installation of Sequel Server. One node will act as the main server and maintain a database called the primary replica. Up to eight additional nodes will each…

Contents