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.