Database Maintenance Plan Wizard

Database Maintenance Plan Wizard is a wizard included with Microsoft SQL Server version 6.0 and later that lets you configure and schedule core maintenance actions for databases.

Sponsor: The only proven system that really works! Winning Sports Picks & Predictions

What is a Database Maintenance Plan Wizard?

A wizard included with Microsoft SQL Server version 6.0 and later that lets you configure and schedule core maintenance actions for databases. You can schedule actions such as:

  • Backups of databases and their transaction logs
  • Updates of optimizer information
  • Checks for damaged data
  • Redistribution of data and free space to make the database more efficient

You can use the wizard to schedule maintenance tasks at daily or weekly intervals. You run the Database Maintenance Plan Wizard from the toolbar of the SQL Server Enterprise Manager administrative tool. You can delete or disable scheduled maintenance tasks if they are no longer required.