up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
feedback

1 Answer

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.

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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