Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.