Transaction log database corruption error on SQL Job

I am having an issue for transaction log database backup getting failed and throw me a following error. 

I never seen this corruption error before so Is there any solution for it?

This error is from my Log file:-

Failed:(-1073548784) Executing the query "BACKUP LOG [Xe] TO  DISK = N'D:\\Xe\\Xe\\Xe_backup_201507230922.trn' WITH NOFORMAT, NOINIT,  NAME = N'Xe_backup_20150723092224', SKIP, REWIND, NOUNLOAD,  STATS = 10
" failed with the following error: "BACKUP detected corruption in the database log. Check the errorlog for more information. 
BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

This is from SQL JOB error"- 

Message
Executed as user: SqlAdmin. ...ion 9.00.5324.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  9:22:20 AM  Progress: 2015-07-23 09:22:24.08     Source: {297F9C99-05AE-47BD-AA70-3E25DDD78CAB}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp".: 100% complete  End Progress  Progress: 2015-07-23 09:22:24.91     Source: Back Up Database (Transaction Log)      Executing query "EXECUTE master.dbo.xp_create_subdir N'D:\Xe".: 50% complete  End Progress  Progress: 2015-07-23 09:22:24.92     Source: Back Up Database (Transaction Log)      Executing query "EXECUTE master.dbo.xp_create_subdir N'D:\Xe".: 100% complete  End Progress  Progress: 2015-07-23 09:22:25.24     Source: Back Up Database (Transaction Log)      Executing query "BACKUP LOG [Xe] TO  DISK = N'D:\Xe\Xe\Xe_b".: 100% complete  End Progress  Error: 2015-07-23 09:22:25.86     Code: 0xC002F210     Source: Back Up Data...  The package execution fa...  The step failed.


July 23rd, 2015 10:32am

BACKUP detected corruption in the database log. Check the errorlog for more information. 


Have you already done what the message suggested, checking ErrorLog file? Which error message do you find there?
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2015 10:49am

This is the error message from error log.

This error is from error Log file:-

Failed:(-1073548784) Executing the query  LOG [Xe] TO  DISK = N'D:\\Xe\\Xe\\Xe_201507230922.trn' WITH NOFORMAT, NOINIT,  NAME = N'Xe_backup_20150723092224', SKIP, REWIND, NOUNLOAD,  STATS = 10
" failed with the following error: "BACKUP detected corruption in the database log. Check the errorlog for more information. 
BACKUP LOG is terminating abnormally.". Possible failure: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

July 23rd, 2015 10:52am
Spooky. I would do what the error message suggests: "Check the errorlog for more information." It might take a while to find the root cause, but hopefully the root cause happened between your prior clean log backup and the first log backup that generated this error. Then the traditional: DBCC CHECKDB, root cause analysis, possible restore or whatever your investigation leads you.
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2015 10:52am

"BACKUP detected corruption in the database log. Check the errorlog for more information. 

Please do the following:

  1. Check the log and post the information for this event to the forum.
  2. Run the following command on the database:
DBCC CheckDB ('XE') WITH NO_INFOMSGS

July 23rd, 2015 10:54am

Adding to what others have said,Checkdb wont be able to detect all errors related to transaction log as it does not does completes consistency check of transaction log you can refer to below link as try few steps to get over with corruption in transaction log , sometimes they are very tricky

Transaction Log backup and corruption

Make sure you find out reason for corruption and unless you mitigate it don't p

Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2015 12:06pm

Good catch regarding CHECKDB not bothering about explicitly checking the transaction log, Shanky.

And, good read.

Monty, I definitely recommend you to read the article Shanky referred to!

July 23rd, 2015 1:11pm

Good catch regarding CHECKDB not bothering about explicitly checking the transaction log, Shanky.

And, good read.

Monty, I definitely recommend you to read the article Shanky referred to!

Free Windows Admin Tool Kit Click here and download it now
July 24th, 2015 2:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics