We had a failure with our SQL Server log shipping job. sp_readerrorlog reported:
Backup detected log corruption in database X. Context is Bad Middle Sector. LogFile: 2 'D:\Database\X_log.MDF' VLF SeqNo: x3f116 VLFBase: x1ede0000 LogBlockOffset: x1f55f600 SectorStatus: 2 LogBlock.StartLsn.SeqNo: x3f116 LogBlock.StartLsn.Blk: x3bf8 Size: x1800 PrevSize: x1400
We've checked the disk for errors; nothing found. So it's not really clear why the log is corrupt, but obviously we'll need to get the log shipping going again.
One possible way forward is documented in this post I found: http://www.sqlskills.com/BLOGS/PAUL/post/How-can-a-log-backup-fail-but-a-full-backup-succeed.aspx
...but wondering if anybody else has seen this happen, and would appreciate any other thoughts as to root cause for this behaviour, and other ways of dealing with the issue.