Basics of Database Corruption Repair

Please join me on Saturday March 16 in Victoria BC Canada for my SQL Saturday presentation on the Basics of Database Corruption Repair.

Here is the session, the Basics of Database Corruption Repair.

Duration: 60 minutes
Track: Admin
Level: Intermediate

Your database is running fine month after month with no problems. Suddenly someone reports that their query won’t run. They get an error stating “SQL Server detected a logical consistency-based I/O error“, or something even scarier. Do you know what to do now? We will walk through 3 corrupt databases exploring ways to go about finding and fixing the corruption. More importantly we will explore how to prevent further data loss at the time corruption occurs. Learn what things you can do to protect yourself when corruption strikes. Learn how to avoid making things worse, and how to protect your data if things do get worse. You will leave with a checklist of steps to use when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.

Prerequisites: some basic DBA experience.

Come see the demo to see what to do if you see this specific error:

Msg 8630, Level 16, State 1, Line 201
Internal Query Processor Error: The query processor encountered
an unexpected error during execution (HRESULT = 0x80040e19).

I hope to see you there on Saturday.

Basics of Database Corruption Repair

Leave a Reply Cancel reply

Login