Database Maintenance Plan Properties (General Page)
When connecting to Microsoft SQL Server 2000 servers, use the Database Maintenance Plan Properties General page to configure the database maintenance plan name and the databases affected. 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. Use maintenance plans instead.
Use this page to view or specify the following options.
- Plan name
Specify the name of the database maintenance plan.
- All databases
Generate a database maintenance plan that runs maintenance tasks against all instances of SQL Server.
- All system databases (master, model and msdb)
Generate a database 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 database 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 database 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.