O'Reilly logo

SQL Server 2014 with PowerShell v5 Cookbook by Donabel Santos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating an AlwaysOn Availability Group

In this recipe, we will create an Availability Group in the primary instance.

Getting ready

It is worth having a refresher on some of the AlwaysOn terminology:

  • A primary is the active instance and is the source of all the updates. This was referred to as the principal in database mirroring.
  • A secondary is the instance that receives all the updates from the primary. In database mirroring, this was referred to as the mirror and was unreadable because it was left in the restoring state. In AlwaysOn, there can be up to four secondary replicas with different synchronization modes. Secondary replicas can also be readable.
  • An Availability Group defines the unit of a failover. This includes defining the group of user ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required