History Cleanup task is very straightforward. It simply removes old data from the
msdb database, and that's it. Over time, as backup and restore jobs run, as SQL Server Agent jobs run, and as Maintenance Plans run, historical data about each of these jobs is stored in tables of the
In the short term, data stored in
msdb can be useful. For example, if you are having problems with SQL Server Agent jobs, or Maintenance Plans, then this past
msdb data can be used to help troubleshoot what went wrong. Also, SSMS uses the data stored in
msdb about backup jobs to make it easier for you to use SSMS to restore databases or log files. Of course, you can also restore backups and logs using T-SQL commands ...