This chapter completes our run through each of the tasks available through the Maintenance Plan Wizard and, perhaps fittingly, is where we clean up after ourselves.
If you run regular
Backup Database tasks (full, differential, and transaction log) as part of the Maintenance Plans you create using the Maintenance Plan Wizard, you may find that a lot of backup files are being stored on the local server, and this can very quickly eat up a lot of disk space.
In addition, if your Maintenance Plans write a report each time any maintenance task is executed, as I recommended in Chapter 3, then a text file will be created and stored each time. While these text files are generally small, many hundreds of them can be created ...