Adding a replica to a SQL Server Availability Group

Before you begin

You must have a SQL Server Availability Group and an instance in the WSFC not hosting a replica of the Availability Group.

To add a replica to a SQL Server Availability Group

1. From the Management Console, navigate to the Availability Group on which you want to add the replica.
2. Select Provision > Add Replica to SQL Server Availability Group.

3. In the General page, populate the following fields, and click Next.

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   
   

4. In the Replicas Selection page, populate the following fields, and click Next.

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   
   

5. In the Endpoints page, configure the endpoint settings for the selected instances and click Next.

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   
   

6. In the Backup Settings and Priorities page, populate the following fields, and click Next.

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   
   

7. In the Synchronization Settings page, select what type of synchronization is used to create the Availability Group, and click Next.

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   
   

8. In the Custom Scripts Configuration page, select any pre-provisioning or post-provisioning scripts that you want to run as follows, and click Next.

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   
   

9. In the Job Options page, specify any of the following Job options, and click Next.

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
   
   

10. If the Change Control page displays, populate the following fields, and click Next.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.
    
    

    Warning

    Note

    The Change Control page appears only when change control is configured for your environment. See Configuring-change-control.

11. In the Summary page, review the provisioning information.
    To make changes, do the following:
    1. Click Go to to return to the provisioning step that you want to edit.
    2. Make your changes.
    3. Click Save and Review to return to the Summary page.
12. Specify your verification preferences.
     For additional information, see Understanding-pre-verification-tests.
    • To continue with adding the replica to the Availability Group after the pre-verification tests have been successfully run without manual intervention, select Automatically Continue If All Tests Succeed.

    • To add the replica to the Availability Group without having first run the pre-verification steps, select Skip Pre-Verification Tests.

      Warning

      Note

      The Skip Pre-Verification Tests option should only be used when you are certain all tests can succeed. The option skips verification and advances directly to the actual provisioning activity.

13. Click Add Replica to SQL Server Availability Group.
    A progress page appears followed by a success message upon completion. The new replica now appears in the Contents page for this SQL Server Availability Group.

    Warning

    Note

    Detailed current and historical information about this action can be viewed in the Jobs section of the Management Console. See Monitoring-jobs-and-viewing-job-history.