When connecting to Microsoft SQL Server 2000 servers, use the Database Maintenance Plan Properties Integrity page to automate a check of the database integrity. New database maintenance plans cannot be created with SQL Server Management Studio. Use Enterprise Manager instead. Database maintenance plans cannot be created on Microsoft SQL Server 2005 or later versions of SQL Server. Use maintenance plans instead.
Use the Integrity page to run data integrity tests, which detect corrupted data. Corruption sometimes may be caused by a hardware or software errors.
Check database integrity
Check the allocation of data pages in the database.
Check allocations in indexes and data pages when testing database integrity.
Attempt to repair any minor problems
Automatically attempt to correct any minor problems detected during the internal data integrity tests. The database must be in single user mode to execute this option.
Check allocations only in data pages when testing database integrity. It is faster to use this test than to test the database with indexes because fewer pages are checked.
Perform these tests before backing up the database or transaction log
Execute the database or internal data integrity tests before backing up the database or transaction log. If the integrity tests detect inconsistencies, subsequent database or transaction log backups are not backed up.
Set the frequency at which the data integrity tasks (scheduled using SQL Server Agent) are executed. The default is every Sunday at 12:00 midnight.
Display the Edit Recurring Job Schedule dialog box, where you can change the default schedule