Adding replicas to SQL Server availability groups

To add a database replica:

  1. In the left pane of the ESI window, select Applications > SQL Server Groups.

  2. In All Groups, select the SQL Server and instance for the replica.

  3. Click Script Execution and then click Add Replica.

  4. On the Add Replica page, specify the following.

Field

Description

  1. Server

SQL Server in the availability group

Instance

SQL Server instance in the availability group

Availability Group

Availability group for the database replica

Candidate Replica Server

Candidate server for the replica

Candidate Replica Instance

Candidate instance for the replica

Shared Network Location

Browse to select the folder or type the shared folder path for the group.

Show Script

Select to show the T-SQL script, which appears after adding the replica.

  1. Click Add Replica.

  2. When the added replica message appears, click OK.

 

Related links

 

 SQL Server Adapter overview

 ESI overview

 Adding SQL Servers

 Home window

 Viewing SQL Servers

 Adding SQL Server databases to DAGs

 Creating SQL Server databases

 Using T-SQL script