Database Integrity Check
Use the Database Integrity Check screen to view or specify the following options.
Check database integrity
Check the allocation and structural integrity of user and system tables, and indexes in the database, by running the DBCC CHECKDB Transact-SQL statement. This ensures that any integrity problems with the database are reported, thereby allowing them to be addressed later by a system administrator or database owner.
Check the data and index pages in the database during the integrity tests.
Attempt to repair any minor problems
Attempt to correct any minor problems detected during the database integrity tests automatically. When this option is selected, the database will be put in single user mode each time the maintenance plan runs. It is recommended that this option be selected.
Check only the data pages in the database during integrity tests. This does not check indexes. This option executes faster than clicking Include indexes because fewer pages in the database are checked.
Perform these tests before doing backups
Cause the database and/or internal data integrity tests to be executed before backing up the database or transaction log. If the integrity tests detect inconsistencies, any subsequent database or transaction log backup is not backed up.
Set the frequency that the data integrity tasks (scheduled using SQL Server Agent) are executed. The default is every Sunday at 12:00 midnight.
Change the default schedule.