Posted by John Bell on 06/12/72 11:26

Hi Trevor

I assume you have read
http://support.microsoft.com/default.aspx?scid=kb;en-us;326485

You may want to look at writing the history to a text file and the option to
do more verbose logging from SQL agent in:
http://support.microsoft.com/kb/288577/

Also check out which database you are applying the plan to:
http://support.microsoft.com/default.aspx?scid=kb;en-us;303292

You may want to consider writing your own set of maintenance routines that
give you more information.

HTH

John

"Trevor Best" <googlegroups@besty.org.uk> wrote in message
news:1126482331.316173.127270@z14g2000cwz.googlegroups.com...
>I have a maintenance plan on a client's site, there's only one database
> in the plan and it's set to backup db and log, this job fails
> consistently. The one step in the job contains this line:
>
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> 392B2334-6800-4655-A6C7-5414D9072505 -WriteHistory -VrfyBackup
> -BkUpMedia DISK -BkUpDB "C:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\DailyBackups" -DelBkUps 4WEEKS -BkExt "BAK"'
>
> Which fails if run in QA with the message:
>
> Server: Msg 22029, Level 16, State 1, Line 0
> sqlmaint.exe failed.
>
> I've searched for this error and cannot find anything to help.
> There's no "-S" in the path, it writes absolutely no history on the
> plan. I set the plan to write history in the log directory on the
> server, it wrote nothing to that directory.
>
> The database doesn't get backed up but is able to be backed up manually
> to the path specified in the plan. I also have a separate job with a
> SQL backup statement in it that works OK so SQLAgent is working.
>

[Back to original message]