Configuring and Validating the Replication Agent Resource File
A single installation of the Replication Agent can support replication from multiple databases. However, one Replication Agent instance is needed for each Microsoft SQL Server database that is to be replicated.
First-Time Initialization
To initialize the primary data server, Replication Agent for Microsoft SQL Server installs objects at the data-server level and at the database level.
Subsequent initialization
Create another Replication Agent instance, after you have already initialized the primary data server.