Transaction Log Backup Failing as Deadlock Victim

Newsgroups	comp.databases.ms-sqlserver
Date	2014-01-28 12:58 -0800
Message-ID	<a226b43d-9e59-4686-b21c-b818fed76ef8@googlegroups.com> (permalink)
Subject	Transaction Log Backup Failing as Deadlock Victim
From	Mark D Powell <Mark.Powell2@hp.com>

Show all headers | View raw

Recently my 64 bit SQL Server 2008 R2 RTM Enterprise Edition failover cluster running under Windows 2008 R2, the transaction log backup job has begun to fail every now and then with "was deadlocked on lock resources with another process and has been chosen as the deadlock victim"  Thirty minutes later when the next set of log backups run the task will run fine.

This server is overdue to be migrated to a new cluster where it will can be patched, but I was wondering if anyone has seen this and knows of an article on the subject.

Thank you
Mark D Powell

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Transaction Log Backup Failing as Deadlock Victim Mark D Powell <Mark.Powell2@hp.com> - 2014-01-28 12:58 -0800
  Re: Transaction Log Backup Failing as Deadlock Victim Erland Sommarskog <esquel@sommarskog.se> - 2014-01-28 22:55 +0100
    Re: Transaction Log Backup Failing as Deadlock Victim rja.carnegie@gmail.com - 2014-01-28 16:58 -0800
      Re: Transaction Log Backup Failing as Deadlock Victim Erland Sommarskog <esquel@sommarskog.se> - 2014-01-29 08:34 +0000
        Re: Transaction Log Backup Failing as Deadlock Victim Mark D Powell <Mark.Powell2@hp.com> - 2014-01-30 12:34 -0800
          Re: Transaction Log Backup Failing as Deadlock Victim Mark D Powell <Mark.Powell2@hp.com> - 2014-01-30 13:07 -0800

csiph-web