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,
    Tuesday, June 12, 2018 1:11 PM

All replies

  • 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.
    Tuesday, June 12, 2018 1:17 PM