Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Size of distribution database used in transactional replication has increased significantly, it is almost double of the database being replicated. Size of replicated database is 18 GB and distribution database is 35 GB.

Is this normal? If so can someone point me to resources where I can get some information about how to assess size of distribution database in future.

Please note, it is SQL 2008.

share|improve this question
up vote 1 down vote accepted

What is the free space in the database? Also check if the Clean Up Task for the Distribution database is working fine.

share|improve this answer
clean up task was not working earlier, I fixed it yesterday. Free space is 28GB :). I think the culprit was the cleanup task. Should I simply shrink the database? – Mani Jul 27 '10 at 11:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.