db maint plan fail

Hi ,
i am trying to set up a database maintainenance plan on SQL server 2000 with
SP3 on Windows 2000 server but i encountered the following error :
Executed as user : NT AUTHORITY\SYSTEM. sqlmaint.exe failed (SQLState 42000)
Error : 22029. The step failed
could anyone advise ?
tks & rdgsHi,
Could you tell us what sort of job you are performing using Maintenance
Plan. If it is Transaction log backup ensure that your database recovery
models selected for backup must be either FULL or BULK_LOGGED. If it is
SIMPLE then log backup will fail.
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:1764E240-8F7F-4A96-B316-095633386279@.microsoft.com...
> Hi ,
> i am trying to set up a database maintainenance plan on SQL server 2000
> with
> SP3 on Windows 2000 server but i encountered the following error :
> Executed as user : NT AUTHORITY\SYSTEM. sqlmaint.exe failed (SQLState
> 42000)
> Error : 22029. The step failed
> could anyone advise ?
> tks & rdgs|||Hi ,
i am backing up only the master , msdb & model dbs and i have changed the
mode to full backup however , i still got the same error
rdgs
"Hari Prasad" wrote:

> Hi,
> Could you tell us what sort of job you are performing using Maintenance
> Plan. If it is Transaction log backup ensure that your database recovery
> models selected for backup must be either FULL or BULK_LOGGED. If it is
> SIMPLE then log backup will fail.
> Thanks
> Hari
> SQL Server MVP
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:1764E240-8F7F-4A96-B316-095633386279@.microsoft.com...
>
>|||Hi
If you right click on the plan in Enterprise Manager and call up the
Maintenance Plan History do you get a more detailed error message?
Also are you just performing backups or are you also defining integrity
checks. If so do not attempt to repair minor problems on the system DBs as
the process cannot get exclusive access to master or msdb (too many other
processes).
Yours
Alasdair Russell
"maxzsim" wrote:
[vbcol=seagreen]
> Hi ,
> i am backing up only the master , msdb & model dbs and i have changed t
he
> mode to full backup however , i still got the same error
> rdgs
>
> "Hari Prasad" wrote:
>