Export (0) Print
Expand All

Database Maintenance Plan Properties (Integrity Page)

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.

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. The database must be in single user mode to execute 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

Community Additions

ADD
Show:
© 2014 Microsoft