Online Documentation for SQL Administrator for SQL Server

Check database wizard

Check Database Wizard allows you to perform the check database operation on your SQL Server system (the DBCC CHECKDB Transact-SQL statement is issued).

This operation is used to check the allocation, structural, and logical integrity of all the objects in the specified database.

To run the wizard, select the Tools | Check Database... main menu item or click Check Database... button on the toolbar.

The wizard consists of the following steps:

• Selecting server and databases to check
• Setting schedule options
• Specifying checks to perform
• Setting repair options
• Setting check options
• Checking database