HI Experts
I am having problem with Replication in sql 2005. My Distribution job failing every 10 mins with following Error. and my distribution database is growing and about to occupying entire Drive. its grown up to 88 GB and I have only 20 GB free space . I am trying to clean it but it not working ..
Any suggestion how to trouble shoot.
Error Information:
Date 1/21/2010 10:00:00 AM
Log Job History (Distribution clean up: distribution)
Step ID 1
Server SQL2
Job Name Distribution clean up: distribution
Step Name Run agent.
Duration 00:44:59
Sql Severity 13
Sql Message ID 1205
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: Ginka\SQLSVRAGENT. Transaction (Process ID 217) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed.
Appreciate your quick response.
Thanks
ichbin