log shipping restore failure

I don't understand, have sql 2000 on a win2000server. I set the sqlserver to
startup using the ./administrator account.
I use Windows XP on my destkop and use desktop connection to get to the
server. I log on as the administrator account.
I created a log shipping maintenance plan. As long as I am logged on to the
server, and use the SA account to register the servers in in Ent Manager.
The jobs ALL run fine. Until I log off. Once off, the jobs all go to hell..
The restores all start to fail. The backups still work, but the restores
fail. This happens every time I recreate the jobs. I get the following
erron on the restore
.....Executed as user: CHLSNT010\Administrator. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029). The step failed.
I can't find anything on error 22029.
Can anyone help with this.
Thanks
Gordon
You'll find more details when you right click on the plan and view history
or details ..
"gordon" <gordon@.discussions.microsoft.com> wrote in message
news:EBFCF72E-CE7A-4660-9C4C-812BEE4336E6@.microsoft.com...
> I don't understand, have sql 2000 on a win2000server. I set the sqlserver
to
> startup using the ./administrator account.
> I use Windows XP on my destkop and use desktop connection to get to the
> server. I log on as the administrator account.
> I created a log shipping maintenance plan. As long as I am logged on to
the
> server, and use the SA account to register the servers in in Ent Manager.
> The jobs ALL run fine. Until I log off. Once off, the jobs all go to
hell..
> The restores all start to fail. The backups still work, but the restores
> fail. This happens every time I recreate the jobs. I get the following
> erron on the restore
> ....Executed as user: CHLSNT010\Administrator. sqlmaint.exe failed.
> [SQLSTATE 42000] (Error 22029). The step failed.
> I can't find anything on error 22029.
> Can anyone help with this.
> Thanks
> Gordon
|||Yes, there is no failure there. Only as below. Any ideas why?
"Hassan" wrote:

> You'll find more details when you right click on the plan and view history
> or details ..
> "gordon" <gordon@.discussions.microsoft.com> wrote in message
> news:EBFCF72E-CE7A-4660-9C4C-812BEE4336E6@.microsoft.com...
> to
> the
> hell..
>
>