Online Documentation for SQL Administrator for SQL Server

Check database

Check Database node is used to manage check database maintenance plans.

To open this tab choose the Maintenance | Check Database node of the Server Explorer tree.

Use the context menu or buttons on the work area toolbar to manage checking:

create a new maintenance plan

check database

edit database

create and print the report

The upper area is the grid with the following columns: Database Name, Last Success Date, Has Check Entire DB Schedule, Check Entire  DB Last Execution, Check Entire DB Last Outcome, Schedule Period during a Month (It represents a grey axis with points which correspond to 6-hours intervals, days and weeks. Green lines show the planned time of the checking). If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.

When you choose a particular database the lower area displays the following detailed information about the check database maintenance plans: Check Database Maintenance Plan/Job: Name, Enabled, Last Run Outcome, Last Run Date; Schedule: Schedule Name, Enabled, Description; Task/Job Step: Name, Last Run Outcome, Last Run Duration, Last Run Message.

To open a maintenance plan in the Maintenance Plan Editor, double-click it in the grid or select it and press the 'Enter' button. Alternatively, you can right-click the maintenance plan alias and select the Edit Plans/Jobs context menu item.