Bradβs Sure Guide to SQL Server Maint
β Brad M. McGehee
π Library
π
2009
π Simple Talk Publishing
π English
β¦ LIBER β¦
π
Brad's Sure Guide to SQL Server Maintenance Plans
β Scribed by Brad M McGehee
- Publisher
- Red gate books
- Year
- 2009
- Tongue
- English
- Leaves
- 268
- Series
- DBA Handbooks
- Category
- Library
β¬ Acquire This Volume
No coin nor oath required. For personal study only.
β¦ Synopsis
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
π SIMILAR VOLUMES
Brad's Sure Guide to SQL Server Maintena
β Brad M McGehee
π Library
π
2010
π Red gate books
π English
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 Mainte
Practical Maintenance Plans in SQL Serve
β Bradley Beard
π Library
π Apress
π English
Administrator's Guide to SQL Server 2005
β Buck Woody
π Library
π
2006
π Addison-Wesley
π English
"SQL Server 2005 is a landmark release and this title does an awesome job of hitting everything new in SQL 2005. It covers new and improved administration tools, and contains an overview of Notification Services, SQL Server Service Broker, Reporting Services, Integration Services, and Analysis Servi
Administrator's Guide to SQL Server 2005
β Buck Woody
π Library
π
2006
π Addison-Wesley
π English
ο»ΏBuck Woody's new book will help new and experienced users alike in getting productive with SQL Server 2005 quickly. His special attention to security and performance make this an exceptional reference that is sure to remain relevant for some time. --Chip Andrews, CISSP, MCDBA, Director of Research
Practical Maintenance Plans in SQL Serve
β Beard, Bradley
π Library
π
2016
π Apress
π English
This book is a complete guide to setting up and maintaining maintenance plans for SQL Server Database Administrators. Maintenance plans too often consist of a backup task and that's it, but there is so much more that can and must be done to ensure the integrity of your most important company resourc