SQL Server Performance

Distribution Database Growth

Discussion in 'SQL Server 2005 Replication' started by melvinlusk, Oct 27, 2009.

  1. melvinlusk Member

    I have a SQL 2005 transaction replication setup with a dedicated distributor. The Distribution database has grown to over 3 GB in just a few days. This seems unusual.....what job removes outdated transactions from this database?
    melvinlusk, Oct 27, 2009
    #2

  2. johnson_ef Member

    HI,Usually, distribution cleanup job will take care of this issue.Check this link; this will help you.
    http://dbaspot.com/forums/ms-sqlserver/269542-msrepl_commands-clean-up.html
    johnson_ef, Oct 28, 2009
    #3

  3. melvinlusk Member

    I found it....the retention period for keeping replicated transactions is specified in the Distribution Clean-Up Job.
    Thanks for your help!
    melvinlusk, Oct 28, 2009
    #4

Share This Page