Error: 3041, Severity: 16, State: 1 ;Backup detected log corruption in database DatabaseName. Context is FirstSector
There is a Transaction log backup scheduled on my production server. On one bad day the Transaction log backup sql agent job throwing error and the error was like below. And I have found this error in the ERROR path(Eg:C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG)
Error: 3041, Severity: 16, State: 1
Backup detected log corruption in database DatabaseName. Context is FirstSector. LogFile: 2 'E:\MSSQL\DATA\DatabaseName.ldf' VLF SeqNo: x541af1 VLFBase: x42e20000 LogBlockOffset: x43785c00 SectorStatus: 2 LogBlock.StartLsn.SeqNo: x6320656c LogBlock.StartLsn.
Blk: x6f6e6e61 Size: x656e
And the steps I have done to fix this issue is:
However Transaction log backup is not working.
1) Take the database full backup
2) Change the Data base recovery model from FULL to Simple(breaking the log backup chain and removing the requirement that the damaged portion of log must be backed up)
3) Run CHECKPOINT
4) Again change the recovery model from Simple to FULL
5) Again take FULL Backup in order to successful backups of Transaction logs
After doing above steps my transaction log backup started working successfully.
Error: 3041, Severity: 16, State: 1
Backup detected log corruption in database DatabaseName. Context is FirstSector. LogFile: 2 'E:\MSSQL\DATA\DatabaseName.ldf' VLF SeqNo: x541af1 VLFBase: x42e20000 LogBlockOffset: x43785c00 SectorStatus: 2 LogBlock.StartLsn.SeqNo: x6320656c LogBlock.StartLsn.
Blk: x6f6e6e61 Size: x656e
And the steps I have done to fix this issue is:
However Transaction log backup is not working.
1) Take the database full backup
2) Change the Data base recovery model from FULL to Simple(breaking the log backup chain and removing the requirement that the damaged portion of log must be backed up)
3) Run CHECKPOINT
4) Again change the recovery model from Simple to FULL
5) Again take FULL Backup in order to successful backups of Transaction logs
After doing above steps my transaction log backup started working successfully.
Comments
This is comprehensive and helpful list. There I found one more very informative article describing about SQL Server Backup Detected Corruption In the Database Log. You may also have a look on this:
http://www.sqlmvp.org/backup-detected-corruption-in-the-database-log/