Unanswered: replication - why log grows for distribution database?
I have setup transactional replication in sql server 2000 and move close 2 Million rows a day. The distribution database is setup on say D1. The data file size is 500 MB but the log file grows upto 26 GB also sometimes. There are no changes to the replication setup per se. The distribution database is in FULL mode. What is causing the log file to grow so large for the distribution database and any suggestion to control this growth.