How to Setup multiple distributors for single publisher db in SQL Server 2014


  • Hi,

    I have 2 replications running on the server both of them are using the same source db. How ever I would like to select a different distributor for one of the publication and the other one using the distributor configured in the publisher server. Is that possible in SQL server 2014?

    Thanks & Regards,
    Dienstag, 12. Juni 2018 13:11

Alle Antworten

  • This can't be done. Multiple publishers can use different distribution databases on a remote distributor, but you can't configure multiple publications on the same server to use different distribution databases.
    Dienstag, 12. Juni 2018 13:17