Database Maintenance Plan (General Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Database Maintenance Plan (General Tab)

Use this tab to view or specify the following options.

Options

Plan name

Specify the name of the maintenance plan.

All databases

Generate a maintenance plan that runs maintenance tasks against all instances of Microsoft® SQL Server™.

All system databases (master, model and msdb)

Generate a maintenance plan that runs maintenance tasks against each of the SQL Server system databases. No maintenance tasks are run against user-created databases.

All user databases (not master, model and msdb)

Generate a maintenance plan that runs maintenance tasks against all user-created databases. No maintenance tasks are run against the SQL Server system databases.

These databases

Generate a maintenance plan that runs maintenance tasks only against the databases you select from the list. If you choose this option, you must select at least one database. This option is the default.

See Also

Database Maintenance Plan Wizard