Today i saw a DB was in Recovery state and i wanted to check why it was in recovery state for a log time, so i checked the SQL Error Log and from the Error log i found the below error Message.
ERROR MESSAGE:
==============
An error occurred while processing the log for database 'X'. If possible restore from backup. If a backup is not available<c/> it might be necessary to rebuild the log.
11/04/2013 21:17:29,spid17s,Unknown,Error: 9004<c/> Severity: 21<c/> State: 1.
CAUSE:
======
The Transaction Log File is Corrupted.
Resolution :
========
Fix the corruption by restoring from the latest backup or Rebuild the log file.
ERROR MESSAGE:
==============
An error occurred while processing the log for database 'X'. If possible restore from backup. If a backup is not available<c/> it might be necessary to rebuild the log.
11/04/2013 21:17:29,spid17s,Unknown,Error: 9004<c/> Severity: 21<c/> State: 1.
CAUSE:
======
The Transaction Log File is Corrupted.
Resolution :
========
Fix the corruption by restoring from the latest backup or Rebuild the log file.
Getting such very errors is really irritating for anyone but need not to be panic as it's a resolvable issue. Get more:-http://en.mssqldatabaserepair.org/
ReplyDelete