Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Scaling out the Distribution database Expand / Collapse
Posted Friday, November 15, 2013 11:26 AM


Group: General Forum Members
Last Login: Tuesday, March 29, 2016 11:59 AM
Points: 120, Visits: 977
Is it possible to assign different publications from the same publisher, to different distribution databases located on a different server? Example: Server A has 2 publications (Delta and Echo). Server B has 2 distribution databases (Delta_Distribution and Echo_Distribution). Can you assign the Delta publication to the Delta_Distribution database and likewise for Echo?

I was reading the following article.

Which lead me to believe that you cannot assign different publications within the publisher to different distribution databases? On the distribution server, in the distribution properties, you must select one distribution database that serves as the default for all publications that are inherent in that publisher. Therefore, if you have only one Publisher and one distributor, can you not scale out the distribution databases?


Post #1514807
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse