I have a SQL Server 2008r2 database server running on Windows Server 2008. On this server every week the log of at least one database throws this error:
Backup detected log corruption in database dbname. Context is FirstSector. LogFile: 2 'L:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\dbname_1.ldf' VLF SeqNo: xe1c94 VLFBase: x280900000 LogBlockOffset: x282d9d600 SectorStatus: 2 LogBlock.StartLsn.SeqNo: xd0010047 LogBlock.StartLsn.Blk: x213b Size: x6400 PrevSize: x8496
I can fix this but I want to know why the error appears frequently. I do not see disk problems in the event viewer. I'm doing log backups every hour with Tivoli TSM. It is a virtual server over VMWare.
Why do log files get corrupted frequently? Where can I start looking?