question

David Wimbush avatar image
David Wimbush asked

Log backups failing because of corruption

I'm having a little trouble with my log shipping. The log backup failed with this sequence of error messages: Backup detected log corruption in database tracking. Context is FirstSector. LogFile: 2 'G:\sqllog\tracking_log.LDF' VLF SeqNo: x69d88 VLFBase: x8450000 LogBlockOffset: x8453e00 SectorStatus: 2 LogBlock.StartLsn.SeqNo: x69c72 LogBlock.StartLsn.Blk: x1f Size: x400 PrevSize: x200 Error: 3041, Severity: 16, State: 1. BACKUP failed to complete the command BACKUP LOG tracking. Check the backup application log for detailed messages. This happened about a year ago on this server and I put it down to a freak event. Now it's happened twice in a week. Different database each time. I can fix the corruption easily enough but I'm starting to worry I might be heading for a disk problem. I've checked the disk for errors in the drive properties and it says everything's fine. What do you guys recommend, please?
transaction-logcorruption
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
Solved! We updated the firmware on the server and the problem stopped. Still no idea why it used to work fine and then went bad.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Wilfred van Dijk avatar image
Wilfred van Dijk answered
Could you provide the OS version, SP and SQL version and SP?
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi Wilfred. It's SQL 2008 R2 Standard Edition 64 RTM (build 10.10.1600). Windows Server 2008 R2 Standard Edition RTM.
0 Likes 0 ·
If you want to be sure the disk is not the problem, I suggest you to move your logfile to another disk. The easiest way is to 1) take the database offline, 2) use "alter database" to change the logfile location, 3) copy the logfile, 4) bring database online
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.