What to Do When DBCC CHECKDB Reports Corruption

Database corruption is something that you hope you never have to deal with, but is eventually going to happen to everyone if you deal with databases long enough. In this article from Brent Ozar, we get his take on the steps to resolve the issue, as well as when and how to communicate the status of the issue to your team.

  1. Query the msdb.dbo.suspect_pages table.
  2. If it’s just one database, send an email to your manager and your team.
  3. If you’re using a SAN, alert the storage team.
  4. Alert the application owners and stakeholders.
  5. Turn off your backup-delete jobs: you’re gonna need ’em.
  6. Review the history of your CHECKDB and backup jobs.
  7. If you have the full CHECKDB output, look for an easy fix.
  8. Fork your recovery efforts into multiple teams.
  9. Send out a status update as work starts.
  10. Keep working the plan.

You should read the entire article for all the details.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s