# of distribution server for a publishing server

Hi,
Does anybody know if I can have more than one distribution server for a
publishing server ?
explanation:
I have a publishing server which contains 2 databases. I want to publish the
first database to Distribution server 1, and database 2 to distribution
server 2. Is this possible ?
I can't see any reason why not, though I've never personally tried it.
There is a limit of one distributor per published database, since there can
only be one log reader reading any one transaction log at a time.
Gail Shaw (MCSD)
http://gail.rucus.net/
"Remon Bekker" wrote:

> Hi,
> Does anybody know if I can have more than one distribution server for a
> publishing server ?
> explanation:
> I have a publishing server which contains 2 databases. I want to publish the
> first database to Distribution server 1, and database 2 to distribution
> server 2. Is this possible ?
|||can't be done.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Remon Bekker" <Remon Bekker@.discussions.microsoft.com> wrote in message
news:D30D226D-3065-403C-9543-97BAA4EA7654@.microsoft.com...
> Hi,
> Does anybody know if I can have more than one distribution server for a
> publishing server ?
> explanation:
> I have a publishing server which contains 2 databases. I want to publish
the
> first database to Distribution server 1, and database 2 to distribution
> server 2. Is this possible ?
|||You can have more than one publisher per distribution database but not
vice-versa.
Rgds,
Paul Ibison