Cleanup History and Maintenance Clean-up History related to Maintenance Plan. It is a bit confusing but they are totally different . If we are designing maintenance plan then we should also create cleanup history and maintenance clean-up history.
Clean up History
The History Clean-up task deletes historical data about Backup and Restore, SQL Server Agent, and Maintenance Plan operations. This wizard allows us to specify the type and age of the data to be deleted.This actually delete the information from system tables of msdb.
Maintenance Clean-up History
The Maintenance Clean-up task removes files left over from executing a maintenance plan. This delete files from the drive which we have taken through maintenance plan.
Clean up History
The History Clean-up task deletes historical data about Backup and Restore, SQL Server Agent, and Maintenance Plan operations. This wizard allows us to specify the type and age of the data to be deleted.This actually delete the information from system tables of msdb.
Maintenance Clean-up History
The Maintenance Clean-up task removes files left over from executing a maintenance plan. This delete files from the drive which we have taken through maintenance plan.
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757