Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL - Nice 8.9
- Thread starter cellspam
- Start date
nicetechie
Technical User
There are basically four different commands that can be run to check various levels of consistency within your database. The four options are listed below with a short description of each as listed in SQL Server Books Online.
DBCC CHECKALLOC - Checks the consistency of disk space allocation structures for a specified database
DBCC CHECKCATALOG Checks for catalog consistency within the specified database.
DBCC CHECKDB - Checks for catalog consistency within the specified database.
DBCC CHECKTABLE Checks the integrity of all the pages and structures that make up the table or indexed view.
The most widely run option is DBCC CHECKDB because it checks the entire database, but the other options are helpful for quicker spot checking. In addition, all of these commands have additional options that can be selected to check for only a portion of the data and also for repairing any corruption that has been found.
DBCC CHECKALLOC - Checks the consistency of disk space allocation structures for a specified database
DBCC CHECKCATALOG Checks for catalog consistency within the specified database.
DBCC CHECKDB - Checks for catalog consistency within the specified database.
DBCC CHECKTABLE Checks the integrity of all the pages and structures that make up the table or indexed view.
The most widely run option is DBCC CHECKDB because it checks the entire database, but the other options are helpful for quicker spot checking. In addition, all of these commands have additional options that can be selected to check for only a portion of the data and also for repairing any corruption that has been found.
- Status