No. of Distribution Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hassan (fatima_ja_at_hotmail.com)
Date: 02/19/05


Date: Sat, 19 Feb 2005 14:17:54 -0800

How many distribution databases can we have ? ... Say I have one publisher
/Published DB and multiple subscribers.

Can I have as many distribution dbs as the no. of subscribing dbs or just
one per published db or just one per publisher ? Can someone get my basics
straight ?



Relevant Pages

  • Re: multilpe distribution databases?
    ... It is true that you can add multiple distribution databases. ... correct that each publisher can only use one distribution database. ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication Performance -- Many publishers, 1 subscriber
    ... publisher and multiple subscribers, as the metadata and alerts etc are then ...
    (microsoft.public.sqlserver.replication)