Home / server / Questions / 164411
Accepted
Mani
Asked: 2010-07-28 03:10:58 +0800 CST

How to reduce size of Distribution database used in MSSQL replication

  • 772

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.

sql-server-2008 replication

1 Answers

  1. Best Answer

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

    • 1