Creating a SQL Server Database Maintenance Plan

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