Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    9

    Unanswered: Transactional Replication and Deadlock + Suspect Agent Errors for over 80 Databases

    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 their snapshot agents start for those 80 databases, they start giving the deadlock error. All 80 snapshot agents starts at the same time.

    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???

  2. #2
    Join Date
    May 2002
    Posts
    299
    Take a look at this kb:
    http://support.microsoft.com/kb/246330
    --
    -oj
    http://www.rac4sql.net

  3. #3
    Join Date
    Nov 2003
    Posts
    9

    Smile

    Thank you very much oj_n. I thought I was doing something wrong but now every thing is clear.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •