Groups > comp.databases.ms-sqlserver > #1645

Transaction Log Backup Failing as Deadlock Victim

X-Received	by 10.58.154.5 with SMTP id vk5mr1396825veb.32.1390942728883; Tue, 28 Jan 2014 12:58:48 -0800 (PST)
X-Received	by 10.182.28.70 with SMTP id z6mr18481obg.16.1390942728532; Tue, 28 Jan 2014 12:58:48 -0800 (PST)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!peer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!f11no9315793qae.1!news-out.google.com!wo6ni17igb.0!nntp.google.com!c10no4414006igq.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Tue, 28 Jan 2014 12:58:48 -0800 (PST)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=15.219.153.76; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
NNTP-Posting-Host	15.219.153.76
User-Agent	G2/1.0
MIME-Version	1.0
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>
Injection-Date	Tue, 28 Jan 2014 20:58:48 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
X-Received-Bytes	1631
X-Received-Body-CRC	1550761887
Xref	csiph.com comp.databases.ms-sqlserver:1645

Show key headers only | 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