O'Reilly logo

Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. History Cleanup Task

The 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 msdb database.

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required