O'Reilly logo

Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

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

Chapter 19. Create and Modify Maintenance Plans Using the Designer

It has been quite a long journey through the Designer to get to the point where we are ready to design, create, test, and schedule a full Maintenance Plan.

In this chapter, we'll walk through the full process of creating from scratch, and deploying, a Maintenance Plan that could be used to perform the following essential database maintenance tasks:

  • back up database data and log files

  • run regular database integrity checks

  • perform index rebuilds

  • delete old data from the msdb database

  • remove old backup and report files that are no longer required to be stored on the local server

  • notify the designated operator, should one of the tasks fail.

While the example does perform many of the essential ...

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