Distribution Cleanup Agent FAILS

• Cláudia Sousa Rego

  SSCommitted

  Points: 1780

  More actions

  September 14, 2006 at 3:29 am

  #94368

  Hi!!

  I have a big problem and need help urgently!!!

  Yesterday, after i submited a large quantity of data to my replicated DB, i started having a problem:

  Distribution Cleanup Agent (form Miscelaneous Agents) fails and consequently, after 10 minutes, Replication Agent Checkups fails.

  What can i do??

  Thanks,

  claudia

  ---

  Regards,

  Cláudia Rego

  www.footballbesttips.com

• Cláudia Sousa Rego

  SSCommitted

  Points: 1780

  More actions

  September 14, 2006 at 7:49 am

  #660386

  I found the answer! The problem is that my distribution DB has full.

  After i shrink the distribution transaction log, i could start normally all my agents and replication started working.

  Ând i didn't lost data!

  Thanks

  Cláudia

  ---

  Regards,

  Cláudia Rego

  www.footballbesttips.com