SQL 2005 Maintenance Wizard Part 1

SQL 2005 Maintenance Wizard Part 1: "There are a number of database housekeeping tasks that should be done on a regular basis to insure SQL performance and data integrity are optimized. Backing up the database, reorganizing data and index files, compressing the data file, updating the index statistics, and performing consistence checks are a few examples. All of these tasks can be executed using TSQL commands. However, SQL 2005 includes a graphical wizard (Maintenance Plan Wizard) that makes selecting these tasks and their options easy. In addition, the wizard will roll all of your selected tasks into a reusable and customizable package. "