© Bradley Beard 2016

Bradley Beard, Practical Maintenance Plans in SQL Server, 10.1007/978-1-4842-1895-2_6

6. Cleaning Up Maintenance Files

Bradley Beard

(1)Palm Bay, Florida, USA

Very similar to the content of Chapter 5 is the topic of maintenance cleanup tasks . History and maintenance tasks probably could have been tied together, but I can understand why they are separate.

Separation of History from Maintenance

Why are cleanup tasks separate for history and maintenance? Let’s look at the differences between the two tasks. Figure 6-1 highlights some of the key differences to be aware of.

A396023_1_En_6_Fig1_HTML.jpg
Figure 6-1. Differences between Maintenance and History Cleanup ...

Get Practical Maintenance Plans in SQL Server: Automation for the DBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.