Wednesday, February 22, 2012 3:41 AM
Just get a maintenance plan guide from vendor asking us to perform "Maintenance Clean Up" - Once a day, 3 days after last successful backup AND "Clean Up History" - Once a month.
We would like to seek your advice whether "Maintenance Clean Up" should be after "Transaction Log / Database Backup" ? If it is run once a day, 3 days after last successful backup, does it mean that it will keep the database and transaction log backup for 3 days ?
On the other hand, what will be the "Clean Up History" ? What will be cleaned up ? Is there any SQL Script that I can run interactively to perform "Clean Up History" task ?
Your advice is sought.
- Edited by TonyJK Wednesday, February 22, 2012 3:43 AM
Wednesday, February 22, 2012 9:47 AM
Maintenance clean up task is to basically remove the old backups (.bak and .trn) after a specific interval.
History cleanup is to cleaup the history of the backups, maintenance plans etc.
What you need to do is to edit the current maintenance plan which does backup and add tasks ("maintenance clean up" and "cleanup history")which runs after the success of the backup tasks to do these tasks.
This Link gives you altenatives for cleaning up history.
Regards, Ashwin Menon My Blog - http:\\sqllearnings.wordpress.com
- Proposed As Answer by Sean GallardyMicrosoft Community Contributor, Editor Wednesday, February 22, 2012 1:52 PM
- Marked As Answer by TonyJK Friday, February 24, 2012 12:06 AM
Friday, April 20, 2012 7:31 AM
Using using Maintenance cleanup task we can we can delete .bak files,.trn and .txt files
using History cleanup task we can delete .bak,.trn , .txt files and also we can delete sql agent job historry which is available in error log file