• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 759
  • Last Modified:

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!
0
data_bits
Asked:
data_bits
  • 2
1 Solution
 
dannygonzalez09Commented:
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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now