The topic for this month’s T-SQL Tuesday #182 hosted by Rob Farley (Blog) is integrity. Read on to see my thoughts on integrity in the world of databases – in particular database corruption.
Read More »
Tag: database corruption
SQL Server Database Corruption! Fixing and Preventing
In my previous post, SQL Server Database Corruption! Understanding and Diagnosing, we talked about database corruption. We discussed what it was so we could better understand the threat we face. Then we learned how to diagnose database corruption. Today we are going to talk about remediating and preventing database corruption.
If you haven’t already read the previous post please read it first.
SQL Server Database Corruption! Understanding and Diagnosing
Of all the things that can ruin your day as a DBA and possibly get you fired, database corruption ranks right up there with backups and security enforcement of the database. Database corruption can be a resume generating event! A corrupt database can affect system stability, lead to unnecessary downtime, and possibly the loss of some data. To manage the risk you must know what database corruption is, how to diagnose, how to fix, and how to prevent.
Read on to learn how to understand and diagnose database corruption.
UPDATE: Part 2 on Fixing Database Corruption