Database Maintenance Plans allow you to automate many database administration tasks in 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

• Home
• Types of Databases
• Database Maintenance

Top Rated Professionals takes the time to review each vendor so that you can feel confident they are a quality provider of their service.