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