March 16, 2018 at 12:25 pm
I would like to create a new distribution database specifically for a publication and then assign that publication to use that newly created distribution database. The publisher and distributor are on the same SQL instance. Is the possible and if so, how would I accomplish this?
I would like to do this because I need to set the transaction retention differently for the new distribution database.
Thank you.
March 19, 2018 at 2:12 am
Hi,
this is a very good page for scaling out distribution:
http://www.sqlservercentral.com/articles/Replication/69663/
kind regards,
Andreas
March 19, 2018 at 2:26 pm
Andreas,
Thank you for the response. I read through the post you directed me to and it explains the process of assigning a publisher to a new distribution database. My issue is that I have two publications within a publisher and I would like to have each of those publications use their own distribution database. Both publications are within the same publisher. Is there a way to assign each publication to their own distribution database and both publications are within the same publisher?
Thanks
March 19, 2018 at 2:33 pm
Hi,
sorry for my missunderstanding.
I think it is not possible, to use 2 distribution databases for one publisher.
We were not able to do this with sql server 2012.
Maybe now it is possible, but i think not.
March 19, 2018 at 2:48 pm
Thank you for the quick response. I was afraid of that. I will work on an alternate solution. Thanks again.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply