DevOps Articles

Curated articles, resources, tips and trends from the DevOps World.

SQL Server Database Corruption Detection

4 years ago dzone.com

Summary: This is a summary of an article originally published by the source. Read the full original article here →

by Database corruptions do not occur normally, but when they occur, it is always a very troublesome and tense event for DBAs.

We, as DBAs, do not often have much to do in avoiding corruption, but we may try to detect them as early as possible.

If the database is formed in a newer version of SQL Server, by default CHECKSUM is set.

DBCC CHECKDB is the commonly used command by database administrators to find the corrupt files and fix them.