Monitoring Databases  «Prev  Next»

Lesson 11 Database Maintenance plan Wizard
Objective Use the database maintenance plan Wizard.

Database Maintenance Plan Wizard for SQL-Server

The database maintenance plan Wizard can be used to automate standard maintenance tasks. This Wizard will create a SQL Server Agent Job that runs sqlmaint.exe. The database maintenance plan Wizard is executed from SQL-EM by following these steps:
  1. Select the Server group
  2. Select the SQL Server
  3. Select Tools Database Maintenance from the menu

Wizard Functionality

The database maintenance plan Wizard walks you through reorganizing your database, using dbccs to test the database integrity, scheduling database backups, generating reports containing the output from the commands you have run, and logging information about what tasks where performed.
View the SlideShow below to see the database maintenance plan Wizard.

High Performance SQL Server Database Maintenance Plan Wizard
Initial Database Maintenance Plan Wizard screen.
1) This is the initial database maintenance plan wizard screen
1) This is the initial database maintenance plan wizard screen.

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

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

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

5) Database Maintenance Plan Wizard 5
5) The Database Backup screen allows you to schedule a full database backup.

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

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

High Performance SQL Server
8) The Specify Transaction Log Backup Disk Directory screen allows you to pick backup file options.
8) The Specify Transaction Log Backup Disk Directory screen allows you to pick backup file options.

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

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

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

The next lesson concludes this module.
SEMrush Software