March 25, 2009 at 11:58 am
I am setting up initial maintenance plans for our customers using SQL 2005 and 2008.
I am able to create Maintenance Cleanup Tasks based on the success of the Full Backup, and deleting all .bak files older than 2 weeks. Same for the Transaction Log Backup and deleting .trn files older than 2 weeks.
However if, for example, the full backups start failing. It is possible that Trans log backups could continue for a while before they discover that the full backups hadn't been running.
I am looking for a way to run the Maintenance Cleanup tasks job in such a way that it checks for the success of the last run of both the Full and Transaction log jobs (the last time they were run). This job could be triggered by the run of either of these jobs but would need to check for the success of both jobs.
The full backups run Sundays, Tran backups run all other days.
Any suggestions on how to best accomplish this?
March 25, 2009 at 11:19 pm
Using Maintenance Plane Wizard there is an option to give separate schedule for each task as subplans.
So What i suggest is that we schedule subplan1 A full backup plan on Sunday and the next sublan2 log backup daily and then sublan3 a cleanup task on Sunday one success on both these.
Tanx 😀
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply