When defining an HDR server pair within Enterprise Replication, the HDR server pair must appear to be a single logical entity within the replication domain. To accomplish this, define the two HDR servers within the same database server group in the SQLHOSTS file. For example, Figure 18 illustrates two Enterprise Replication nodes, one of which is an HDR pair.
In this example, the HDR pair consists of the primary server, serv1, and the secondary server, serv1_sec. These two servers belong to the same database server group, g_serv1. The non-HDR server, serv2, belongs to the database server group g_serv2. The following example displays the SQLHOSTS file for this configuration.
| dbservername | nettype | hostname | servicename | options |
|---|---|---|---|---|
|
g_serv1 serv1 serv1_sec g_s |