Loopback Configuration
To setup loopback replication, define pseudo ER group in SQLHOSTS, and define new service within DBSERVERALIAS other than the one used for primary ER group name. Service name added for loopback pseudo group should appear after service name used for primary Enterprise Replication group.
SQLHOSTS file example:
g_er_server group - - i=1
er_server onsoctcp *myhost 17001 g=g_er_server
g_loopback group - - i=2
loopback onsoctcp *myhost 17002 g= g_loopback
DBSERVERALIAS example:
DBSERVERALIAS er_server,loopback
where g_er_server is the primary group name
for the local server, g_loopback is the pseudo ER group name for the local server.