Database Maintenance Plan (Integrity Tab)
Use the Integrity tab to run data integrity tests, which detect corrupted data. Corruption sometimes may be caused by a hardware or software errors.
Options
Check database integrity
Check the allocation of data pages in the database.
- Include indexes
- 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. It is recommended that you select this option.
Exclude indexes
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.
Schedule
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.
Change
Display the Edit Recurring Job Schedule dialog box, where you can change the default schedule.