Creating a SQL Server Database Maintenance Plan

By Mike Chapple, About.com Guide

Database Maintenance Plans allow you to automate many database administration tasks in Microsoft SQL Server. You can create maintenance plans using an easy wizard-based process without any knowledge of Transact-SQL.

You may perform the following tasks within a database maintenance plan:

• Shrinking a database
• Backing up a database
• Performing an operator notification
• Updating database statistics
• Verifying the integrity of a database
• Cleaning up leftover maintenance files
• Executing a SQL Server Agent job
• Executing a Transact-SQL statement
• Rebuilding an index
• Reorganizing an index
• Cleaning up database histories

Previous

• Choose the tasks that will be part of your plan
• Starting the Database Maintenance Plan Wizard
• Name the Database Maintenance Plan
• Schedule your Database Maintenance Plan
• Select the Tasks for your Maintenance Plan
• Ordering the Tasks in the Database Maintenance Plan
• Configure the Plan's Task Details
• Choose Maintenance Plan Reporting Options

Next