Creating Maintenance Plans
Maintenance plans provide a mechanism to graphically create job workflows that support common administrative functions of backup, re-indexing, and space management.
Tasks that are supported by maintenance plans are:
Backup of databases and transaction logs
Updating of statistics
Performing consistency checks
I do not use maintenance plans. I write the T-SQL script to issue the backups directly using a job instead of using SSIS as a backup engine.
In this exercise, you will create a maintenance plan to back up the AdventureWorks database.
Create a Maintenance Plan
Under the Management Node, right-click ...