SQL Server Full backup maintenance plan reports failure, yet log shows success
Posted on 2014-02-10
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)
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?