October 25, 2017 at 2:38 am
Hi
I have to setup Push Transactional replication between 2 servers, and the Publisher will also act as the Distributor.
The publisher has about 50 databases that must all be replicated. The Subscriber will then be a readable secondary for reporting.
My question is: For the configuration and after-setup maintenance, what is the best option for the Publication?
-- Should I create One Publication with all the databases and all objects?
-- OR Should I create a separate Publication for each database?
-- Based on the number of Publications, should I have 1 or multiple distribution databases?
What is the best option, specifically to make maintenance and administration of Replication easier?
October 25, 2017 at 3:38 am
Hi,
a view years ago we decided to use one distribution database per publisher.
We had a lot of databasess and much traffic on the transactionlog.
With only one distritubiton database we got locking / blocking on the distribution database.
After we used on database per publisher, no more blocking/ locking exist.
Kind regards,
Andreas
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply