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 17. Configuring Maintenance Tasks Using the Designer

Having explored the Designer GUI in some detail in the previous chapter, we're now ready to investigate how to use the Designer to configure each of the eleven maintenance tasks that are available. You may be thinking that these are exactly the same eleven tasks we saw when using the Maintenance Plan Wizard, but that's not quite the case. Eight of the eleven tasks (Check Database Integrity, Rebuild Index, Reorganize Index, Update Statistics, Shrink Database, History Cleanup, and Maintenance Cleanup) are logistically more or less identical to the ones we configured through the Wizard. We'll cover most of these tasks in relatively little detail, avoiding as far as possible repetition of ...

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