SQL Server Performance

distribution--cleanup agent not working properly

Discussion in 'Getting Started' started by lara99, Aug 10, 2009.

  1. lara99 New Member

    hi all we have a situation in our office.the distribution clean up agent is not getting rid of the old transaction.what could be the reason do you gurus faced this problem before.what are the effective ways of shrinking the distribution databaseplease share your expereiences.thanks,lara
  2. MohammedU New Member

    Do you see any error message in error log or job history?
    Is replication cleanup job running?
  3. lara99 New Member

    i dont see any error messages and yes the distribution cleandup is executing fine every 4 hrs.thanks,

Share This Page