It has been quite a long journey through the Designer to get to the point where we are ready to design, create, test, and schedule a full Maintenance Plan.
In this chapter, we'll walk through the full process of creating from scratch, and deploying, a Maintenance Plan that could be used to perform the following essential database maintenance tasks:
back up database data and log files
run regular database integrity checks
perform index rebuilds
delete old data from the
remove old backup and report files that are no longer required to be stored on the local server
notify the designated operator, should one of the tasks fail.
While the example does perform many of the essential ...