SQL Server Detected a Logical Consistency-based I/O Error

Products

• Carbon Black App Control

Issue/Introduction

• Executing the SQL Query: dbcc checkdb ('das') returns a message similar to:

  CHECKDB found 0 allocation errors and 17 consistency errors in database 'das'. [SQLSTATE 01000]
  repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (das). [SQLSTATE 01000]

• SQL Server logging events similar to:

  SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: .... actual: .... ). It occurred during a read of page ....

Environment

• App Control Database
• Microsoft SQL Server: All Supported Versions

Cause

Database corruption could by caused by many number of things, including faulty hardware, power outages, interference from 3rd party applications during maintenance tasks, etcetera.

Resolution

Work with your SQL Server Admin to determine the next best steps. Most likely, some level of data loss will be involved and your SQL Server Admin will be able to evaluate the situation and determine what options are available/best.

In some instances a database restore to the last known full backup may be required. Alternatively they may opt to attempt a repair of some sort.

Additional Information

• DAS Database Backup Best Practices
• Create a maintenance plan
• DBCC CHECKDB (Transact-SQL)
• Help, my database is corrupt. Now what?