log shipping restore failure

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: gordon (gordon_at_discussions.microsoft.com)
Date: 02/12/05 

Date: Fri, 11 Feb 2005 17:09:01 -0800

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

Relevant Pages

  • Re: Log shpping security/access problem....
    ... I log on as the administrator account. ... > server, and use the SA account to register the servers in in Ent Manager. ... the jobs all go to ... The backups still work, but the restores ...
    (microsoft.public.sqlserver.security)
  • Re: log shipping restore failure
    ... >> server, and use the SA account to register the servers in in Ent Manager. ... the jobs all go to ... >> The restores all start to fail. ... The backups still work, but the restores ...
    (microsoft.public.sqlserver.replication)
  • Log shpping security/access problem....
    ... I log on as the administrator account. ... server, and use the SA account to register the servers in in Ent Manager. ... the jobs all go to hell.. ... The restores all start to fail. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Service Accounts
    ... > feeding" of SQL Server 2000. ... > DBA tasks at prior jobs, so I'm not a complete novice. ... > account and the servers are set for mixed security. ...
    (microsoft.public.sqlserver.security)
  • Error with Log shipping auto restore
    ... I log on as the administrator account. ... server, and use the SA account to register the servers in in Ent Manager. ... the jobs all go to hell.. ... The restores all start to fail. ...
    (microsoft.public.sqlserver.setup)