View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 03:17 AM
Simon Hayes
 
Posts: n/a
Default Re: Mostly backup jobs fail with Generic error sqlstate 42000 error 22029


"Vincento Harris" <wumutek@yahoo.com> wrote in message
news:2fa13ee7.0406180605.464a42f7@posting.google.c om...
> Jobs are run from a master server and all the servers run the same
> jobs.
>
> A new server has been added and the jobs tested so far, ran OK but
> for backups.(Transaction logs and database)with above listed error.
>
> The same domain account is used for the agent and the sql server
> engine for all databases
>
> Out of ideas after browsing the web for a while
>
> Your input on this is more than welcome
>
> Vincento


There are several possible reasons (search Google newsgroups for "sql 42000
22029"), but you should try to get more detailed information about the
error. What does it say in the maintenance plan report file or the
msdb.dbo.sysdbmaintplan_history table? I'm assuming that you're using a
maintenance plan, since all of the hits in Google for that error message
refer to using sqlmaint.exe.

If this doesn't help, please post some more information - which version of
MSSQL, which backups fail (system database or user databases), what recovery
model do those databases have, what options have you selected in the
maintenance plan (eg. "attempt to repair minor problems") etc.

Simon


Reply With Quote