Source: dzone.com
SQL Server Database Corruption DetectionCategory: Database, Data
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.
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.
Related Articles
Community Partners
DevOps Careers