DBCCCHECKDB Ensures the Integrity of Your Database and Should be Used Prior to Backup
Description:
DBCC CHECKDB checks the data integrity of all objects in the database. It should be used before backing up a database to make sure that your database is sound.
(back to top)Requirements:
None
(back to top)Setup:
None.
(back to top)GUI Steps:
None. This is a T-SQL command.
(back to top)T-SQL Steps:
1) Connect to the Northwind Database and execute the DBCC CHECKDB command. You will get a long stream of output for the objects in the database, then a notification about any errors that may have been found.
2) We received the following at the end of the results pane indicating that no errors have been found.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'Northwind'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
(back to top)