Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Scaling out the Distribution database Expand / Collapse
Author
Message
Posted Friday, November 15, 2013 11:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:41 AM
Points: 114, Visits: 903
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.
http://www.sqlservercentral.com/articles/Replication/69663/

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?

Thanks,
DK

Post #1514807
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse