Clever Geek Handbook

Transactional replication

What is the maximum number of publishers that can be created in one database on the same database server?

Moreover, on the contrary,

What is the maximum number of subscribers that can be created in one database on the same database server?

+1


source to share


2 answers


Why do you have subscribers on the same database server? Why do you need multiple publishers in one database? Perhaps you should explain the problem you are trying to solve.

Only one publisher is required for each database. One distributor can distribute many subscribers. The distribution agent is usually located on a different server to the publisher; subscribers can be located on the same server as the distributor.



The maximum number of subscribers is mainly limited by the network bandwidth and the capacity of the disks on which the publisher's transaction log file is stored.

+1


source


I haven't heard of a "logical" post / subscription limit. Your limitation will either be related to licensing (some versions of SQL have limited publishing rights) or hardware issues as noted by @Mitch



0


source






More articles:


All Articles