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

Joining the secondary replicas to Availability Group

In this recipe, we will join the secondary replicas to an existing Availability Group.

Getting ready

Before we proceed with this recipe, the availability group needs to be created. Let's take a look at the Creating an AlwaysOn Availability Group recipe.

As documented on MSDN, the prerequisites to join the secondary replicas are as follows:

  • The primary replica should be online
  • The join command to join the secondary replicas to the availability group needs to take place at the secondary server instance that hosts the secondary replicas
  • The secondary instance must be able to connect to the database mirroring endpoint of the primary instance

Since we need to execute the command on the secondary instances, ...

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