This topic describes the options of the Specify Replicas page. This page applies to the New Availability Group Wizard and the Add Replica to Availability Group Wizard of SQL Server 2014. Use the Specify Replicas page to specify and configure one or more availability replicas to add the availability group. This page contains four tabs, which are introduced in the following table. Click the name of a tab in the table to go to the corresponding section, later in this topic.
Use this tab to specify each instance of SQL Server that will host or currently hosts a secondary replica. Note that the server instance to which you are currently connected must host the primary replica.
Finish specifying all the replicas on the Replicas tab before starting the other tabs.
Use this tab to verify any existing database mirroring endpoints and also, if this endpoint is lacking on a server instance whose service accounts use Windows Authentication, to create the endpoint automatically.
Indicates the role that the new replica will initially perform: Primary or Secondary.
Automatic Failover (Up to 2)
Select this checkbox only if you want this availability replica to be an automatic-failover partner. To configure automatic failover, you must choose this option for the initial primary replica and for one secondary replica. Both of these replicas will use the synchronous-commit availability mode. Only two replicas can support automatic failover.
If you selected Automatic Failover (Up to 2) for the replica, Synchronous Commit (Up to 3) is also selected. If the check box is blank, select it only if you want this replica to use synchronous-commit mode with only planned manual failover. Only three replicas can use synchronous-commit mode.
For each server instance that will host an availability replica, the Endpoints tab displays actual values of the existing database mirroring endpoint, if any, or suggested values for a potential new endpoint that would use Windows Authentication. For both existing and potential endpoints, the Endpoint values grid displays the following information:
Displays the name of a server instance that will host an availability replica.
Displays the actual or proposed port number of the endpoint. For a proposed new endpoint, you can change this value.
Displays the actual or proposed name of the endpoint. For a proposed new endpoint, you can change this value.
Indicates whether data sent over this endpoint is encrypted. For a proposed new endpoint, you can change this setting.
SQL Server Service Account
Username of the SQL Server service account.
For a server instance to use an endpoint that uses Windows Authentication, its SQL Server service account must be a domain account.
This requirement determines your next configuration step, as follows:
If every server instance is running under a domain service account, that is, if the SQL Server Service Account column displays a domain service account for every server instance, click Next.
If any server instance is running under a non-domain service account, you need to do make a manual change to your server instance before you can proceed in the wizard. In this case, clicking Next brings up a warning dialog box; you should click No, which returns you to theEndpoints tab. While leaving the wizard on the Specify Replicas page, make one of the following changes to each server instance for which the SQL Server Service Account column displays a nondomain service account, either:
To specify where backups should occur, choose one of the following options:
Specifies that backups should occur on a secondary replica except when the primary replica is the only replica online. In that case, the backup should occur on the primary replica. This is the default option.
Specifies that backups should never be performed on the primary replica. If the primary replica is the only replica online, the backup should not occur.
Specifies that the backups should always occur on the primary replica. This option is useful if you need backup features, such as creating differential backups, that are not supported when backup is run on a secondary replica.
Specifies that you prefer that backup jobs ignore the role of the availability replicas when choosing the replica to perform backups. Note backup jobs might evaluate other factors such as backup priority of each availability replica in combination with its operational state and connected state.
Use the Replica backup priorities grid to specify your backup priorities for each of replicas of the availability group. This grid contains the following columns:
Displays the name of the instance of SQL Server that hosts the availability replica.
Backup Priority (Lowest=1, Highest=100)
Assign the priority for backups being performed on this replica relative to the other replicas in the same availability group. The default value is 50. You can select any other integer in the range of 0..100. 1 indicates the lowest priority, and 100 indicates the highest priority. If you set Backup Priority to 1, the availability replica will be choosen for performing backups only if no higher priority availability replica is currently available.
To prevent this availability replica from ever being be chosen for performing backups. This is useful, for example, for a remote availability replica to which you never want backups to fail over.
Specify your listener preferences for this availability group, as follows:
Listener DNS Name
Specify the network name of the listener. This name must be unique on the domain and can contain only alphanumeric characters, dashes (-), and hyphens (_), in any order. When specified by using the Listener tab, the DNS name can up to 15 characters long.
If you enter an invalid DNS listener name (or port number) on the Listener tab, the Next button is disabled on the Specify Replicas page.
Specify the TPC port used by this listener.
If you enter an invalid port number (or DNS listener name) on the Listener tab, the Next button is disabled on the Specify Replicas page.
Use the drop list to select the network mode to be used by this listener, one of:
Select if you want the listener to listen on more than one subnet. To use the static IP network mode, an availability group listener must listen on every subnet that hosts an availability replica for the availability group. For each subnet, click Add to select a subnet address and to specify an IP address.
If Static IP is selected as the network mode (this is the default selection), a grid displays the Subnet and IP Address columns, and the associated Add and Remove buttons are displayed. Note that the grid is empty until you add the first subnet.
Displays the subnet address that you selected for each subnet you have added for the listener.
IP Address column
Displays the IPv4 or IPv6 address that you specified for a given subnet.
Click to remove the subnet that is currently selected in the grid.
Select if you want the listener to listen on a single subnet and to use a dynamic IPv4 address that is assigned by a server running the Dynamic Host Configuration Protocol (DHCP). DHCP is limited to a single subnet that is common to every server instance that host an availability replica for the availability group.
We do not recommend DHCP in production environment. If there is a down time and the DHCP IP lease expires, extra time is required to register the new DHCP network IP address that is associated with the listener DNS name and impact the client connectivity. However, DHCP is good for setting up your development and testing environment to verify basic functions of availability groups and for integration with your applications.
When DHCP is selected, the Subnet field is displayed.
If you selected DHCP as the network mode, use the Subnet drop list to select an address for the subnet that hosts the availability replicas of the availability group.
After you define an availability group listener, we strongly recommend that you do the following:
Ask your network administrator to reserve the listener's IP address for its exclusive use. Give the listener's DNS host name to application developers to use in connection strings when requesting client connections to this availability group.
Give the listener's DNS host name to application developers to use in connection strings when requesting client connections to this availability group.