May 10, 2007 at 9:51 am
First I went to....
Management Studio > Sql Server agent > right-click Jobs, show History. Shows the nightly backup job failed; no identifiable reason for the failure was provided.
Next I checked the sql 2005 file ERRORLOG file in the Log directory. It showed the job completed successfully.
Next I went to Maintenance plan, right-clicked the job, Show History and that said the job completed successfully.
The application event log on the server showed the job failed.
Finally, I went to our local backup folder to see if the databses were actualy dumped. Yep, I found everyone of them in there.
Any ideas what to check for next?
TIA,
Barkingdog
July 2, 2007 at 6:36 am
Are there any other steps in the job than the backup job if so check also try to log the job so that you can trace where the job writes an error saying it fails.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 3, 2007 at 12:03 pm
If the maintenance plan the scheduled job is running also does a delete of .bak files older than N days and for some reason the older file couldn't be deleted has caused this exact situation. Try deleting the older files as the first step in your maintenance plan and let the backup be the 2nd step.
July 6, 2007 at 6:18 am
What version are you on? Do you do a verify backup? Did you set up for reports to be generated and emailed to you? Sometimes looking at that will show you what part failed in the maintenace plans.
July 7, 2007 at 8:44 am
I thank everyone for their help but I think the winner was making the "delete files older than N days" the first step in the job.
Barkingdog
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply