Part IV. Microsoft SQL Server 2008 Optimization and Maintenance

This part of the book covers administration tools that you’ll use to enhance and maintain Microsoft SQL Server 2008. Chapter 14 provides the essentials for working with server logs, monitoring SQL Server performance, and solving performance problems. Chapter 15 starts by explaining how to create a backup and recovery plan and then discusses common tasks for creating and restoring backups. Chapter 16 explores database automation. You’ll learn how to configure alerts, schedule jobs, and manage database operators. You’ll also learn how to create maintenance plans and resolve database consistency problems. Chapter 17 discusses log shipping and database mirroring. Log shipping and database ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant 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.