question

Swilling avatar image
Swilling asked

Can i add multiple distribution DB's to the distributor?

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!

transactional-replication
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered

There can only be 1 distribution database.

you can add many publishers, publications and subscribers within the same distribution database though.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.