Brad's Sure Guide to SQL Server Maintenance Plans (DBA Handbooks)

Brad's Sure Guide to SQL Server Maintenance Plans (DBA Handbooks), 9781906434342 (1906434344), Red gate, 2010

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

Table of Contents

Chapter 01: Why is Database Maintenance Important?
Chapter 02: Before you Create any Maintenance Plans
Chapter 03: Getting Started with the Maintenance Plan Wizard
Chapter 04: Task Scheduling
Chapter 05: Check database Integrity Task
Chapter 06: Shrink Database Task
Chapter 07: Rebuild Index Task
Chapter 08: Reorganize Index Task
Chapter 09: Update Statistics Task
Chapter 10: Execute SQL Server Agent Job Task
Chapter 11: History Cleanup Task
Chapter 12: Define Back Up Database (Full) Task
Chapter 13: Define Back Up Database (Differential) Task
Chapter 14: Back Up Database (Transaction Log) Task
Chapter 15: Maintenance Cleanup Task
Chapter 16: Using the Maintenance Plan Designer

Comments

Amazing Books

Cartesian Reflections: Essays on Descartes's Philosophy

Oxford University Press, 2008

John Cottingham explores central areas of Descartes's rich and wide-ranging philosophical system, including his accounts of thought and language, of freedom and action, of our relationship to the animal domain, and of human morality and the conduct of life. He also examines ways in which his philosophy has been misunderstood. The Cartesian...

Adobe Photoshop Elements 4 and Premiere Elements 2 All in One (Sams Teach Yourself)

Sams Publishing, 2006

Adobe Photoshop Elements 4 and Premiere Elements 2 All in One is an effective guide to getting things done quickly in these two Adobe digital media applications. Organized into a series of well-organized, bite-sized tasks, this book covers key techniques that will quickly improve your editing skills in both...

Essentials of Knowledge Management

John Wiley & Sons, 2003

"Managing knowledge has become a critical competency for organizations. Despite its importance, knowledge management is often seen as a complex, diffuse, and difficult-to-understand management practice. In his new book, Essentials of Knowledge Management, Bryan Bergeron continues to display his remarkable ability to thoughtfully,...

Databases for Small Business: Essentials of Database Management, Data Analysis, and Staff Training for Entrepreneurs and Professionals

Apress, 2015

This book covers the practical aspects of database design, data cleansing, data analysis, and data protection, among others. The focus is on what you really need to know to create the right database for your small business and to leverage it most effectively to spur growth and revenue.

Databases for Small Business...

Help! I Don't Understand Computers (Help! Guides)

Summersdale Publishers, 2000

This book makes the assumption that the reader has no prior knowledge of computing. It uses everyday language and tries to describe procedures and terms in the simplest way possible. The emphasis is on action and success without wasting time in long technical explanations or terms. Each section is divided up into separate sections that contain...

Future Application and Middleware Technology on e-Science

Springer, 2009

Future Application and Middleware Technology on e-Science presents selected papers from the 2008 Korea e-Science All-Hands-Meeting (AHM 2008). Hosted by the Korea Institute of Science and Technology Information, this meeting was designed to bring together developers and users of e-Science applications and enabling information technologies...