A DBAs guide to the proper handling of corruption

Brandon Leach
60 minutes
Enterprise Database Administration & Deployment
Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have profound impact on our company. In this session we will learn how to detect and respond to various types of corruption. First we will be focus on ways to detect corruption early. This will include understanding tools available to us like DBCC CheckDB as well as the importance of testing your backups. We’ll look at some sample scripts to automate corruption checks and common alerts we should have set up on our instances. Then we will move onto how to respond to some common example of corruption through live demos. We’ll look at how we can analyze the situation safely as well as point out various pitfalls that trip people up. We’ll also discuss when and how we may be able to fix corruption vs restoring the database.
General knowledge of database administration at an entry/junior level.

Accompanying Material

No material found.

Back to Top cage-aids