June 24, 2002 at 9:44 am
Setting: Sql 7, Sp3:
We dump our databases nightly to a local folder. One one box the SqlServerAgent (Management> Sql Server Agent > Jobs> "DB Backup Job for DB Maintenance Plan " ) showed no backup happened last night. No error message either, just no backup. But the Database Maintenance History (Management> Database Maintenance> …Database Backup Plan) shows the dump ran successfully. I checked our local dump folder and found last night's dump (so they did run). DBCC for msdb looks OK. Msdb is set to autogrow so it's not a size limitation either. Any idea what to look at next?
Bill Salkin
June 24, 2002 at 10:11 am
Boot the Maintenance plan?
Don't like these are I have had similar issues (not this though) and no error messages.
There are quite a few scripts in the librar that duplicate this functionality and will allow you to debug the problem.
Steve Jones
June 24, 2002 at 10:27 am
I've had little problem with maint plans. At a loss to explain this one though! I'd try it again, see if it recurs. Maybe you've hit the ceiling for allowed rows in sysjobhistory?
Andy
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply