O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Note

Note

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required