The Implementing Availability Groups module provides you with the instructions and devices to develop your hands on skills in the following topics.

  • Configuring Always On availability groups
  • Creating a new availability group

Lab time: It will take approximately 60 minutes to complete this lab.

Exam Objectives

Two lab objectives are covered in this lab.

  • Configure always on availability groups
  • Create an availability group

Exercise 1 - Configuring Always On Availability Groups

The Always On availability groups feature is a disaster recovery solution. It is an alternative to database mirroring technique. This feature was introduced in Microsoft SQL Server 2012. A set of user databases is made available to the maximum extent with the help of Always On availability groups feature.

In this exercise, you will configure the feature of Always On availability groups on PLABSQL01 and PLABSQL02 devices.

Exercise 2 - Creating a New Availability Group

An availability group supports one set of primary databases. It also supports one to eight sets of corresponding secondary databases. Thus, in an availability group, there is a replicated environment in which there are sets of user databases. The sets of user databases are known as availability databases. An availability replica hosts each set of availability database.

In this exercise, you will create a new availability group with primary and secondary availability replicas.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.