[prod-down] Troubleshoot Data Corruption in SQL Server

Metadata

• Title: [prod-down] Troubleshoot Data Corruption in SQL Server
• Category: prod-down
• Tag(s): SQL Server, Troubleshoot, DBCC
• Description: You want to troubleshoot and fix database consistency errors.

Common Issue(s)

• Database in suspect mode
• DBCC Output: Found N errors and repaired errors
• MSSQLSERVER_824: SQL Server detected a logical consistency-based I/O error
• MSSQLSERVER_832: A page that should have been constant has changed
• MSSQLSERVER2570: Column COLUMNNAME value is out of range for data type "DATATYPE".

Management

• Fixed-time: 1 working day(s)
• Fixed-scope: 1 database
• Fixed-price: $500

Work Breakdown

• Understand symptoms
• Find cause
• Provide solution

Out of Scope

• Root Cause Analysis (RCA)

Deliverable(s)

• Quick fix only
• DBCC CHECKDB should exit with the success message.

Prerequisite(s)

• Database server access
• Screen sharing, if applicable