Udostępnij za pośrednictwem

  • Artykuł

MSSQLSERVER_9004

Details

Product Name

SQL Server

Product Version

10.0

Product Build Number

10.00.0000.00

Event ID

9004

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

LOG_CORRUPT

Message Text

An error occurred while processing the log for database '%.*ls'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.

Explanation

An error was encountered while processing the log during rollback, recovery, or replication. This could indicate an error detected by the operating system-or an internal consistency error detected by SQL Server.

User Action

One of the following actions will correct this error:

  • Restore from a backup.

  • Rebuild the log.

Also, check system event and error logs to identify issues within the system that may have caused the problem.

Internal-Only

<xmrFileHeader><buildNo>10.00.0000.00</buildNo><component>SQLEngine</component><dsDbName></dsDbName><dsProjectName>SQLServer2005</dsProjectName><exportDate>2005-08-22T14:00:12</exportDate><importDate>2005-08-22T12:43:00</importDate><prodContact>pingwang</prodContact><prodName>SQL Server</prodName><prodVer>10.0</prodVer><sourceFileDepotPath></sourceFileDepotPath><sourceFileExt></sourceFileExt><sourceFileName></sourceFileName><userDefined></userDefined><xmrFilePath>.\sqlXMR.xml</xmrFilePath></xmrFileHeader><resourceString resourceStringGuid="b528bb49-340c-4a81-9c8d-cefce6562f16" resourceStringProxyID="MSSQL_ENG009004"><exportStatus>Do Not Export</exportStatus><importStatus>Unchanged</importStatus><inActive>No</inActive><inserts></inserts><message><message /><cause>An error was encountered while processing the log during roll back, recovery, or perhaps replication. This could indicate an OS-detected error or an internal consistency error detected by SQL Server.</cause><causeCorrectiveActionStatus>Dev Signed Off</causeCorrectiveActionStatus><correctiveAction>Restore from a backup, or perhaps rebuild the log</correctiveAction><error><exMsgBoxID></exMsgBoxID><exMsgBoxSource></exMsgBoxSource></error><event><eventCategory></eventCategory><eventFacility></eventFacility><eventLanguage></eventLanguage><eventSeverityType></eventSeverityType><eventType></eventType><momEvent>Yes</momEvent><momOwner>donv</momOwner><winRegEventID>9004</winRegEventID><winRegEventSource>MSSQLSERVER</winRegEventSource></event><msuid></msuid></message><numericID>9004</numericID><owner>ericchr</owner><pssReview><pssComments></pssComments><pssDebugger>No</pssDebugger><pssEngineer></pssEngineer><PSSSupportability>No</PSSSupportability></pssReview><suspect>No</suspect><symbolicName>LOG_CORRUPT</symbolicName><text>An error occurred while processing the log for database '%.*ls'. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.</text><type></type><ueReview><assignedTo></assignedTo><bugID></bugID><bugRequired>No</bugRequired><comments></comments><docStudio><dsTopicId></dsTopicId><export>Yes</export></docStudio><editor></editor><revisedStringText></revisedStringText><workStatus>Not Reviewed</workStatus><writer></writer></ueReview><userDefined><eventLoggingLevel></eventLoggingLevel></userDefined></resourceString>