Routine maintenance tasks must be performed to keep databases performing at optimal state. These maintenance tasks include taking backups of databases frequently, checking the integrity of the databases, rebuilding and reorganizing indexes on databases, updating statistics and cleanup old history. This lab explains how to perform database maintenance tasks using Maintenance Plans Wizard. In the first exercise, we will learn to configure Backup Database Task to take full backup of a database and also learn to schedule the backups. In the second exercise, we will learn to configure Check Database Integrity Task to perform consistency checks on disk space allocation, catalogs, pages and indexes. In the third and fourth exercises, we will learn to configure Rebuild Index Task and Reorganize Index Task respectively. In the fifth exercise, we will learn to configure Update Statistics Task and also learn to schedule the statistics updates. In the sixth exercise, we will learn to configure History Cleanup Task to clear backup and restore history, SQL Server Agent history, and maintenance plans history. In the seventh and final exercise, we will learn to configure all the database maintenance tasks in one plan.

Subscribe to Download


Version1.0
Download0
File Size1.38 MB
Create DateFebruary 11, 2017
Last UpdatedFebruary 11, 2017
Query Store, Live Query Statistics and Live Query Plans
Calling Web Service From SSIS