Detecting Database Corruption – Video
You don’t have to be Sherlock Holmes to detect Server Corruption. Steve Stedman and Derrick Bovenkamp share valuable information on how to spot server corruption… Read More »Detecting Database Corruption – Video
Detecting Corruption
Database Corruption Presentation at Pass Summit 2017
Today I had the opportunity to present on Database Corruption at the PASS Summit 2017 conference. You can download the presentation as a PDF here: Summit… Read More »Database Corruption Presentation at Pass Summit 2017
Database Corruption Overview for Beginners
Database Corruption Overview: Database corruption is one of those things that you can only plan for by practicing your response pla
n. Out of all of the things that can happen to your SQL Server this is the one that you are most likely going to want to ask for help when you encounter it.
What is Corruption?
Database corruption refers to corrupt pages in the database that are incorrectly formatted. This could be as simple as a single bit, or as huge as the entire file. Sometimes this type of corruption prevents the database from starting, other times it may prevents queries from running. Sometimes it may go undetected for some time, and may present as missing or incorrect data.
Presenting at SQL Saturday Las Vegas
This Saturday, September 12th, 2015 I will be presenting at SQL Saturday Las Vegas. My presentation is on Database Corruption, here are the details.
When Database Corruption Strikes – Will you be ready?
Duration: 60 minutes
Track: Enterprise Database Administration & Deployment
You are working along month after month with no problems in your database. 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 or 4 actual 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 should do to protect yourself when corruption strikes. Learn what to avoid that will make things worse. You will leave with a checklist of steps to take when you encounter corruption. By the end of this session you will be ready to take on corruption, one database at a time.
The presentation is scheduled for 11:00 am to Noon in room 2767 at the College of Southern Nevada campus in Vegas.
SQL Server Database Corruption Repair
Database corruption repair with SQL Server is one of those things that you generally don’t see every day, but as a DBA, you are expected to be able to fix it quickly without any data loss. From the risk analysis matrix, it is one of those low frequency high impact scenarios that results in an extremely risky situation. This is one of those situations which could lead to great success, or massive failure depending on your training and skills.
These low frequency, high impact, high risk scenarios are the times that you need to rely on your training, or the training of someone more experienced in these areas.