October 9, 2018 at 11:09 am
Hi All,
Issue : Maintenance plan cleanup task does not delete old backups however T-sql for that task runs fine. please advise.
Description : I have a maintenance plan task where it should delete old backups say 10 days old but it does(runs) all the tasks in maintenance plan, except cleaning task and but does not delete the old backups. When I run the T-SQL for deleting old backups from the cleaning task then it runs fine so I do not think there is any permissions issue. I am able to run in the T-SQL ( to delete old backup which is from the same cleanup task) and clean once a week but how can I permanently fix it. Please advise and share your thoughts.
Error: JOB RUN:'******_MaintenancePlan.DailySubPlan' was run on 10/05/2018 at 2:00:00 AMDURATION:0 hours, 15 minutes, 44 secondsSTATUS: FailedMESSAGES:The job failed. The Job was invoked by Schedule 10 (******_MaintenancePlan.DaylySubPlan). The last step to run was step 1 (DailySubPlan)
October 9, 2018 at 2:16 pm
sizal0234 - Tuesday, October 9, 2018 11:09 AMHi All,Issue : Maintenance plan cleanup task does not delete old backups however T-sql for that task runs fine. please advise.
Description : I have a maintenance plan task where it should delete old backups say 10 days old but it does(runs) all the tasks in maintenance plan, except cleaning task and but does not delete the old backups. When I run the T-SQL for deleting old backups from the cleaning task then it runs fine so I do not think there is any permissions issue. I am able to run in the T-SQL ( to delete old backup which is from the same cleanup task) and clean once a week but how can I permanently fix it. Please advise and share your thoughts.
Error: JOB RUN:'******_MaintenancePlan.DailySubPlan' was run on 10/05/2018 at 2:00:00 AMDURATION:0 hours, 15 minutes, 44 secondsSTATUS: FailedMESSAGES:The job failed. The Job was invoked by Schedule 10 (******_MaintenancePlan.DaylySubPlan). The last step to run was step 1 (DailySubPlan)
Add additional logging and reporting (if its not already there) to the maintenance plan. This will allow you to get more information on the error when you check the log file for the maintenance plan. If you have already done this, check the log files for the maintenance plan.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply