Presented by Robert Davis
Data integrity and corruption can be a complex and scary topic. At some point in your career as a DBA, you will be faced with a potential data loss scenario due to deletion (accidental or not) or corruption. You can’t avoid it. You can only prepare for it and be ready to handle it when it occurs.
Being prepared to handle data loss or corruption starts with the basics of data integrity and disaster preparedness. Then take a deep dive into SQL Server recovery and learn how to handle a wide variety of data loss and corruption scenarios. This class will cover how to be prepared for, prevent, and recover data lost due to deletion or corruption.
You will learn:
- The built-in functionality in SQL Server for preventing and detecting corruption that you might not even know about.
- How to identify a specific transaction in the transaction log and recover data lost from that transaction.
- Categories of corruption and the best way to manage recovery for each one
Who should attend? (skill level, roles): This class is for DBAs of all levels.
Session 1: Data Integrity and Recovery
Data integrity forms the basis for building a disaster recovery strategy. We’ll take a look at the built-in mechanisms for protecting integrity and detecting corruption. We will cover standards and best practices everyone should follow and demonstrate how and why the practices will protect against and prevent data loss.
Session 2: Recovering Lost Data
What do you do when someone forgets the WHERE clause on a delete statement or if a table gets accidentally dropped? We will look at ways to proactively prepare for the recovery of lost data and techniques for recovering the data after it has been lost, including techniques for mining the transaction log for the offending transactions.
Session 3: Handling Corruption
Corruption can happen no matter how much care we take to prevent it. It’s inevitable, so the best course of action is to be ready for when it does happen. We will learn in the earlier sessions how to detect corruption, and now it’s time to learn what to do once you have identified it. We will explore the different types of corruption and the options for handling each type … without data loss.
Robert Davis is a SQL Server 2008 Certified Master, an experienced DBA, evangelist, speaker, writer, trainer, and consultant. He is the Principal DBA with Outerwall, Inc. and consults part-time via SQL DBA Master. He has worked with SQL Server for more than 13 years, including recent stints as a Sr. Product Consultant and Chief SQL Server Evangelist for Idera, Program Manager for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft.