Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Maint Plan Success but Job Failure?

Author  Topic 

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2008-11-04 : 13:43:18
SQL Server 2000, SP3a

I have inherited a database maintenance plan that backs up a 43GB database. Last night the job for the full backup portion of the maintenance plan reported Failure, but the Maintenance Plan history itself reports success. How can this be? There are no other steps in the Job other than executing the maintenance plan.

Side note: For those of you who hate database maintenance plans in SQL 2000, don't bother telling me to dump them. I'm already in the process of doing that. But in the meantime, how is the above situation logical?


---------------------------
EmeraldCityDomains.com
   

- Advertisement -