Database Corruption and DBCC commands
One day I and my colleague was working on a data issue. There was some expected data missing in the table hence, we were analyzing the SQL job which puts the data in the table. However, while discussing this issue we got comment from someone like is it a kind of a data corruption issue? I and my friend looked at each other with shocked eyes. we told that person to keep calm and don’t be panic as this word could create a panic situation unnecessarily. We could able to solve the data issues that day but that person’s comment inspired me to write a blog on data corruption and its resolution. Data corruption could be a nightmare for every DBA. Database security and availability is the topmost priority job of every DBA. In this blog, we will see what is data corruption, which commands we can use to identify corruption and how to get the database in a usable state. What is Data Corruption? Data corruption is when there is an error while reading or updating data in the database. D...