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 3. Getting Started with the Maintenance Plan Wizard

Now that we have all the preliminaries out of the way, we can focus on how to create a Maintenance Plan using the Maintenance Plan Wizard. The marketing story behind the Wizard is "answer a few simple questions on some screens, and voilà, you have a working Maintenance Plan." Of course, the reality is not quite that simple.

While the Wizard does present various configuration options, it does not explain what they do, or their pros and cons. There is also no way to determine if the options you choose are even applicable to your situation.

This chapter will provide a quick overview of the entire process of creating a Maintenance Plan from start to finish, using the Wizard. I'll cover preparation, ...

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