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: Subject: Transaction Log Backup Failing as Deadlock Victim From: Mark D Powell 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 Recently my 64 bit SQL Server 2008 R2 RTM Enterprise Edition failover clust= er 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 anot= her process and has been chosen as the deadlock victim" Thirty minutes lat= er 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 artic= le on the subject. Thank you Mark D Powell=20