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 an availability group

Create an availability group - SQL Server Tutorial

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

Start my 1-month free trial

Create an availability group

“

- [Instructor] A second high availability option for taking advantage of Windows fail over clusters was introduced in the SQL Server 2012 release, and it's called always on availability groups. Availability groups differ from fail over cluster instances in that each node in the cluster gets its own instance of SQL server. The structure looks like this. First, the fail over cluster contains a number of computers called nodes. Each node gets its own copy of SQL Server that can be run independently and simultaneously. Across all of those instances a single availability group was created. Within the availability group are multiple copies of the database that are being protected, one on each fail over node. These are called database replicas. Since each node contains a complete copy of the database, any node in the cluster can act as the primary read-write copy of the database. Every other node in the cluster maintains a secondary copy that is read only. When the node that contains the…

Contents