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 ...

Get Beginning SQL Server 2008 Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.