Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    10

    Unanswered: Multiple Distributors from a single Publisher

    Hi all, I am setting up a 40 subscriber node transactional replication environment (pull), and was looking to have 2 or more distributors service one publisher, each having a group of subscribers, is there any benefit to this ?, as opposed to having one distributor service all subscribers, is it possible (distributor at instance level ?)

    From what I've seen, I could not find anything that shows multiple distributors to one publisher.

    Publisher and Distributor are on separate physical hosts.

    thanks,
    Paul

  2. #2
    Join Date
    Mar 2013
    Posts
    10
    Got my answer

    For the same Publisher,it can only have a Distributor. A Publisher can only use one distribution database. A Distributor can provide one or more distribution databases for different publishers; each of these publishers could use their own distribution database, or they could share a single distribution database with other publishers.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •