SQLBits 2014

Do's and don'ts of database corruption

In this session we'll look at the things you should and shouldn't be doing now, to protect yourself and your data against the risk of corruption and thing you should and shouldn't do should the database ever become corrupt.

Database corruption is one of the worst things you can encounter as a DBA. It can result in downtime, data loss, and unhappy users. What’s scary about corruption is that it can strike out of the blue and with no warning, and without having some way of telling if a database has become corrupt, it could be that way for months or even years before anything gets done about it.

In this session we’ll look at:

  • Easy maintenance operations you should be running right now to ensure the fastest possible identification and resolution of corruption
  • Best practices for handling a database that you suspect may be corrupted
  • Actions that can worsen the problem
  • Appropriate steps to take and options for recovery