>At each night, an automated backup is schedule and i stop/start sql server
during that task.

Could you give me some more information about how this is working. Is this a
sql server agent job?

Could you also give me some background for this backup strategy. In sql
server it is possible to backup a database with the BACKUP DATABASE command
while it is online.

>I have a lot of jobs that was schedule in SQL Server Agent and since 2008-03-13 the status won't be update

What if you just create a simple sql server agent tsql job and execute that?

/Ola



"inf0m286" wrote:

> Hi Ola,
>
> I see no error in the server and agent log file. But, there is something
> strange. At each night, an automated backup is schedule and i stop/start sql
> server during that task. Normally, it create a new SQL log file and it's not
> doing that since 03/17 .
>
> For the account that own SQL Server and Agent, it is the local system
> account (in the definition on these services), so i think it has sysadmin
> rights .
>
> Thanks
>
>
> "Ola Hallengren" wrote:
>
> > You have no error messages in the sql server or sql server agent log file?
> >
> > Does the sql server agent service account have sysadmin rights?
> >
> > Ola Hallengren
> > http://ola.hallengren.com
> >
> >
> >
> > "inf0m286" wrote:
> >
> > > Hi,
> > >
> > > I have a lot of jobs that was schedule in SQL Server Agent and since
> > > 2008-03-13, the status won't be update. But, i know that the job still
> > > running well. But the status of the next run date was OK.
> > >
> > > I have search on the web and i don't see anything that can me.
> > >
> > >
> > > SQL2000 Standard Edition (two instance) (SP4)
> > > Windows 2003 Server
> > >
> > >
> > >
> > >
> > >