O'Reilly logo

Beginning SQL Server 2008 Administration by Carmen Taglienti, Grant Fritchey, Robert E. Walters

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 12. Database Maintenance Plans

In Chapters 10 and 11, we talked a lot about ways in which you can execute both interactive and batch-scheduled database administrative tasks. In this chapter, we will introduce the SQL Server maintenance plan. SQL Server's maintenance plans give you a way to perform an array of database administrative tasks on a defined schedule. There are two ways to create SQL Server maintenance plans:

  • The first is by using the Maintenance Plan Wizard, which we will walk you through in detail in this chapter.

  • The second is to use the maintenance plan authoring environment in Management Studio. Figure 12-1 shows that environment.

Figure 12.1. Maintenance plan authoring environment in Management Studio

It is no surprise that ...

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