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 10. Common Database Maintenance Tasks

Maintaining a SQL Server database is critical to ensuring that your database environment performs reliably and efficiently. Although advances in the SQL Server platform have made maintenance activities simpler and more straightforward, it is critical that DBAs understand the following:

  • Which database maintenance tasks need to be performed and why

  • When to perform them

  • How to perform them

In this chapter, we cover a series of important database maintenance tasks, how to determine whether and when they need to be performed, and ways to perform those tasks. Subsequent chapters build upon this one by showing you how to use different tools, such as PowerShell, and by showing you how to define maintenance plans ...

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