Select Databases

Use the Select Databases screen to view or specify the following options.

Options

All databases

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

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 (all databases other than 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 against only those databases that are selected. At least one database in the list must be selected if this option is chosen.

Ship the transaction logs to other SQL Servers (log shipping)

Set up log shipping as part of this maintenance plan. For more information, see Log Shipping.

Note  This feature is available only in the SQL Server 2000 Enterprise and Developer editions.