SQLConfiguration SQLConfiguration


Monitoring Databases  «Prev 

Database Maintenance Plan Wizard

Initial Database Maintenance Plan Wizard screen.
This is the initial database maintenance plan wizard screen.

The select Database screen allows you to pick the database to run the maintenance plan against.

The Reorganize Database screen allows you to pick which reorganization options you want to use and to schedule how often the database is reorganized.

The Verify Database screen allows you to pick which dbcc commands you want to use and to schedule how often the commands are run.

The Database Backup screen allows you to schedule a full database backup.

The Specify Backup Disk Directory screen allows you to pick backup file options.

The Specify Transaction Log Backup Plan screen allows you to schedule transaction log backups.

The Specify Transaction Log Backup Disk Directory screen allows you to pick backup file options.

The Reports to Generate screen allows you to specify report generation options.

The Maintenance History screen allows you to specify where to record information about the maintenance plan that was run.

The Completing the Database Maintenance Plan Wizard screen allows you to name the maintenance plan.