So you can add other publishers to use the same distribution database via Distributor properties that was created for the default instance, but can you add another distribution DB to that distributor for a newly created DB ?
Example : the CAT database in on server1 which is the publisher. Server 2 is the distributor for the CAT DB and had the distribution DB created. Server 2 is also the used as the subscriber. Now, my team added a new DB that needs to also be replicated. So server 1 has the DOG and CAT database, which is the publisher. Can I add a new dist DB on server 2 called Distribution2 that DOG would use? I don't know what is correct or if it even matters. I just thought having 2 different distribution DB's to handle their own DB makes more sense. Please let me know. thanks a lot!
