Re: 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: Sat, 12 Feb 2005 06:21:04 -0800

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...
> > 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: Setting up Job Thresholds in SQL Server 2000
    ... The function of these jobs is to gather> data from a server in our corporate domain and write it out as a text> file for my other applications to process. ... Sometimes, the host server> has some issues like open cursors etc., which leave my jobs just> hanging and not fail out. ... is there a way to set> thresholds on the duration of the jobs? ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Packages fail when executed from Jobs
    ... I could run the DTS package locally on the server and remotely but was ... unable to run it consistently from the Jobs section. ... > works fine, but if i execute it in the jobs, it will fail. ... > In a remote SQL Server Enterprise, it will fail, both the ways. ...
    (microsoft.public.sqlserver.dts)
  • 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: Setting Job Thresholds in SQL Server Agent
    ... Looking for a book on SQL Server replication? ... The function of these jobs is to gather ... > thresholds on the duration of the jobs? ... > make it fail out then, I would be able to get notifications about it. ...
    (microsoft.public.sqlserver.replication)
  • Re: DTS Packages fail when executed from Jobs
    ... I have the same problem, when executing the DTS directly from the server, it ... works fine, but if i execute it in the jobs, it will fail. ... In a remote SQL Server Enterprise, it will fail, both the ways. ...
    (microsoft.public.sqlserver.dts)