Re: Maintenance Plan "fails"..

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

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 15:51:34 +0200

If I wrote the code, yes a failed deletion of a backup file would cause the job to fail. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Morgan" <abcd@senditon.com> wrote in message news:eVp7v$uTEHA.3988@tk2msftngp13.phx.gbl...
> Hi Tibor,
>
> The only thing in the report file is that it was unable to delete one of the
> database backups. Other than that, all of the steps completed. Would that
> cause the job to think it failed?
>
> Thanks,
>
> Morgan
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
> message news:ubeNMltTEHA.2544@TK2MSFTNGP10.phx.gbl...
> > Any messages in the report file? (Did you specify a report file, btw?)
> >
> > -- 
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Morgan" <abcd@senditon.com> wrote in message
> news:eiY8NRjTEHA.1284@TK2MSFTNGP10.phx.gbl...
> > > Thanks in advance for any insight.
> > >
> > > On occasion, one of my schedule jobs will "fail", in that all tasks
> > > complete, but it still reports failure. Strangely enough, nothing is
> written
> > > to SQL Server log, but I do have the following entry in the Event
> Viewer:
> > > "SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> 'Non-Great
> > > Plains Daily Backup'' (0x01BF5D1C32E9FF418D67E99A77A4A014) - Status:
> > > Failed - Invoked on: 2004-06-08 20:00:00 - Message: The job failed. The
> Job
> > > was invoked by Schedule 35 (Schedule 1). The last step to run was step 1
> > > (Step 1)."
> > >
> > > Any ideas on how to troubleshoot this?
> > >
> > >
> > > Thanks,
> > >
> > > Morgan
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: problem with query moving data from 1 dbase to another.
    ... You register a SQL Server instance, where such an instance can have several databases. ... Tibor Karaszi, SQL Server MVP ... > you know how to connect to an existing database, ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Auto Exiting Store Procedures
    ... "Peter" wrote in message ... SQL Server will terminate the batch. ... >>Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Backing up transaction logs gives poor performance.
    ... share and then type in the UNC name. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Inside SQL Server
    ... You could continue reading, check differences and ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Maintenance Plan "fails"..
    ... Any messages in the report file? ... Tibor Karaszi, SQL Server MVP ... > Thanks in advance for any insight. ... > to SQL Server log, but I do have the following entry in the Event Viewer: ...
    (microsoft.public.sqlserver.server)