McGehee B.M. Brad’s Sure Guide to SQL Sever Maintenance Plans

Red Gate Books, 2010. — 277 p. — ISBN: 978-1-906434-33-5.
На англ. языке.In his new book, Brad's Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a "required minimum" level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer.Brad walks through every one of these tasks covering:
The intent of each task and why it's important
How to configure each task and what all the options mean
Scheduling considerations: when and how often should you run the task?
Customizing and extended your Maintenance Plans using the Designer Used carefully, these Maintenance Plan tools represent powerful time-saving devices for any DBA.At each stage of the book, Brad explains clearly the correct and incorrect uses for the tool, and indicates where more advanced solutions, using T-SQL or PowerShell scripting, would be more appropriate.Why is Database Maintenance Important?
Before you Create any Maintenance Plans.
Getting Started with the Maintenance Plan Wizard.
Task Scheduling.
Check database Integrity Task.
Shrink Database Task.
Rebuild Index Task.
Reorganize Index Task.
Update Statistics Task.
Execute SQL Server Agent Job Task.
History Cleanup Task.
Define Back Up Database (Full) Task.
Define Back Up Database (Differential) Task.
Back Up Database (Transaction Log) Task.
Maintenance Cleanup Task.
Using the Maintenance Plan Designer.Why read this book?
Millions of SQL Server instances run in the offices of small and medium-sized organizations and there are many "accidental" DBAs out there whose job it is to maintain them. Often, they find that they don't have the knowledge, experience, or critically the time, to perform the correct level of maintenance on their SQL Server databases, much as they might like to. This can mean poor performance and reduced availability. Regardless of the size of your organization, if your mission critical data becomes unavailable, then business will suffer greatly. The Maintenance Plan Wizard and Designer allow you to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds.