SQL Server Full backup maintenance plan reports failure, yet log shows success

I have a SQL Server 2005 maintenance plan that does full backups of all databases. It had been working flawlessly until recently.

I changed the location where it writes the backup images. From then on, I get an email notification that the backups failed.

When I check on the status of the backups, they all were successful.  The maintenance plan does the following:
 DBCC CHECKDB on each database (system and user)
 Cleanup job
 Full backup of each database
 Backup transaction logs (of databases in FULL recovery mode)
 
I think it is related to the cleanup task. Yet its history shows that it completed successfully.
What's going on here? Should I disable or remove the cleanup task from the maintenance plan?

TIA!
data_bitsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
dannygonzalez09Connect With a Mentor Commented:
Not the best of the solutions but when i had a similar problem before after trying several different things which did not work, i deleted and re created the tasks and the job and everything worked fine
0
 
Anthony PerkinsCommented:
Should I disable or remove the cleanup task from the maintenance plan?
What does the cleanup task actually do?
0
 
data_bitsAuthor Commented:
The cleanup task goes through and deletes .bak and ,trn files older than 14 days. It also purges the history file of things of the same age.
0
 
Anthony PerkinsCommented:
Then I am afraid I have no idea.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.