Home Forums SQL Server 2005 SS2K5 Replication Distribution database is too big; RE: Distribution database is too big;

  • November 25, 2009 at 6:33 am

    #1083945

    Ian Scarlett (11/25/2009)

    Is it the distribution database itself, or the transaction log that is growing?

    If it's the transaction log, check the recovery model. If it's anything other than simple, you need to make sure you're running transaction log backups.

    It is the database itself that is growing. Not transaction log.

    Recovery model is simple.