Use the add parameter with sp_replication_path to create alternate physical paths between the primary database and a Replication Server by associating a RepAgent replication path with a primary connection from the Replication Server.
Using the example replication system consisting of the PDS primary data server, pdb database, and RS1 and RS2 Replication Servers, create two alternate replication paths on the primary database to make a total of three primary replication paths including the default primary replication path.
sp_replication_path "pdb", 'add', "pdb_1", "RS2", "RS2_user", "RS2_password"
create alternate connection to PDS.pdb named PDS.pdb_1 set error class to rs_sqlserver_error_class set function string class to rs_sqlserver_function_class set username to pdb1_maint set password to pdb1_maint_ps with primary only
sp_replication_path "pdb", 'add', "pdb_2", "RS1", "RS1_user", "RS1_password"
create alternate connection to PDS.pdb named PDS.pdb_2 with primary only