Online Documentation for SQL Administrator for SQL Server

Select databases dialog


The Select Databases dialog appears each time you choose the Select... item of the Database(s) drop-down list when creating or editing some maintenance tasks.

 

Maintenance plans - Maintenance Plan Editor - Select databases

 

 

This list displays all databases registered on the server. Here you can define databases against which a maintenance task should be run.

!RadioButton All databases

Generate a maintenance plan that runs maintenance tasks against all Microsoft SQL Server databases except tempdb.

 

!RadioButton System databases

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

 

!RadioButton All user databases

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

 

If you select the !RadioButton Specific databases option then choose among registered databases to define databases for maintenance task by checking the corresponding boxes.

 

!CheckBox Ignore non-online databases

Check this option to backup databases only in case they are online.