Using Transactional replication to replicate a db from Server A to server B using server C as distributor using Pull. Server A has Max Repl Size set to 2147483647. The subscription on Server B is further Republished to Server D using Server C as Distributor
for Server B this time using Push. Undistributed commands for the original publication on Server A are 0, however on server B, for the republication, undistributed commands are HUGE. My initial guess was may be Max Repl Size on Server B also needed to be changed
to 2147483647, similar to server A. Replication shows no errors on the Rep Monitor, and latency for both is under 5 seconds. The distribution db on server C is in simple recovery mode. Please help. Thanks.
View Complete Post