"Thanks" <Tha***@discussions.microsoft.com> wrote in message
news:626C6D2F-F45D-4634-B7D4-20D3E1CE88CD@microsoft.com...
> sqlmaint.exe Fail? [SQLSTATE 42000] (Error 22029).  Step Fail.
>
>
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> 23BD4667-2869-44F7-B4EF-FEB78F1B6400
> -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpDB "C:\DB Backup"
> -CrBkSubDir -BkExt "BAK"'
>
> SQL version 2000
>
> Please give me idea!
>
> Calvin

"Geoff N. Hiten" wrote:

> Look at the maintenance plan history to see exactly what failed.  The SQL
> Job history is useless for troubleshooting maintenance plan failures.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Thanks" <Tha***@discussions.microsoft.com> wrote in message
> news:626C6D2F-F45D-4634-B7D4-20D3E1CE88CD@microsoft.com...
> > sqlmaint.exe Fail? [SQLSTATE 42000] (Error 22029).  Step Fail.
> >
> >
> > EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> > 23BD4667-2869-44F7-B4EF-FEB78F1B6400
> > -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpDB "C:\DB Backup"
> > -CrBkSubDir -BkExt "BAK"'
> >
> > SQL version 2000
> >
> > Please give me idea!
> >
> > Calvin
>
>
>