Transactional Replication and Deadlock + Suspect Agent Errors

Last Post 25 Oct 2005 06:21 PM by Shariq. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Shariq
New Member
New Member

--
24 Oct 2005 12:26 AM
Hi,
I have more than 80 databases on my publisher (SQL Server 2000 SP4), I tried to enable Transaction Replication on all of those databases instantly through some T-SQL programming and DTS Packages. Every thing works fine until the snapshot agents starts to take sanpshot from the publisher databases. As soon as the snapshot agents starts on those 80 databases, they start giving the deadlock error.

Error Message:
Transaction (Process ID xxx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Error Detail:
Transaction (Process ID xxx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
(Source: Server_Distribution (Data source); Error number: 1205)
---------------------------------------------------------------------------------------------------------------

WHY???
Shariq
New Member
New Member

--
25 Oct 2005 06:21 PM
You are not authorized to post a reply.

Acceptable Use Policy