Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Database Maintenance Plan Properties (General Page)

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 or later. 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.

Community Additions

ADD
Show:
© 2015 Microsoft