Regardless of the size of your organization, if your mission critical data becomes unavailable, then the business will suffer greatly. The Wizard and the Maintenance Plan Designer allows you to configure and schedule the tasks of the eleven core database maintenance, ranging from the integrity check, to backup the database, to reorganize and rebuild indexes. Brad walked through every one of these tasks include: The purpose of the duty of each and why they are important How to set up their respective duties and what it all means scheduling option consideration: when and how often should you perform the task? Chapter 02: Before You Make 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: Index Reorganization 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