Creating Maintenance Plans

Maintenance plans provide a mechanism to graphically create job workflows that support common administrative functions of backup, re-indexing, and space management.

Tasks that are supported by maintenance plans are:

  • Backup of databases and transaction logs

  • Shrinking databases

  • Re-indexing

  • Updating of statistics

  • Performing consistency checks



I do not use maintenance plans. I write the T-SQL script to issue the backups directly using a job instead of using SSIS as a backup engine.

In this exercise, you will create a maintenance plan to back up the AdventureWorks database.

Create a Maintenance Plan

  1. Under the Management Node, right-click ...

Get Microsoft® SQL Server® 2008 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.