sql 2000 maintenance plans stopped working

[McBunny]

well they stopped and i cant get them going again

i created a new transaction log backup and that fails too

Executed as user: HSH\Administrator. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

its a generic error message and the job only has 1 step

 

[McBunny]

think i have sorted it lol

 

[cava83]

What was the issue and the solution?

 

[McBunny]

one of the databases has an issue i just needed to exclude it from the plan and all is ok (i just need to sort the db issue now)

 

[cava83]

Wicked,

Thanks for that, could the DB be corrupt ?

Thanks for the update,

G.

 

[McBunny]

yeah i think it is but i have no idea what the db is actually for as its not been set up by me but i now have to look after it

 

[cava83]

Yap, I know the feeling.

It's a pain when you don't know what or why things have been done, but when you need to fix them, you're kind of lost.

I try to document as much as possible to save people in the future from this kind of issue