Re: Scheduled DB Backup Never Executed, Why? Why?

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/20/04 

Date: Tue, 20 Apr 2004 09:40:45 +0530

Hi,

As Dinesh posted.. Please check whether your "SQL Agent" service in SQL
Server machine is
running. If stopped "start" the service and verify whether the job gets
executed.

Incase if the service failed to start, go to Control Panel -- Services-- SQL
Agent Log ON window.. Re- enter the
OS user name and password (if it is not starting in Local system account).
Enter the same OS User you used to start MSSQL
Server service.This will probably solve your issue

Thanks
Hari
MCDBA

"Vito Corleone" <anonymous@discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@phx.gbl...
> Howdy folks,
>
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
>
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
>
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
>
> 2) On Option Tab
> I selected "Verify Backup upon completion"
>
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
>
> Vito Corleone
> President
> Export & Import Oliver Oil Co.

Relevant Pages

  • Re: DTS schedule problem
    ... I found out that the package, sql server agent were running under the SQL ... Who owns the scheduled SQL Agent job? ...
    (microsoft.public.sqlserver.dts)
  • Re: Replication Monitor disappears
    ... account and see if it shows up. ... Looking for a SQL Server replication book? ... When I was setting up replication I had SQL ... Finally I was able to start the SQL Agent service by ...
    (microsoft.public.sqlserver.replication)
  • Re: Cmd line run problem as windows schedule
    ... BOL has a section on account usage for both agent and sql server that details all the options. ... > I have a schedule job with windows scheduler where shows job runs and reslt ... > schedule can't invoke it. ...
    (microsoft.public.sqlserver.programming)
  • Re: Scheduled Backup for SQL Database
    ... and the service does restart ok. ... >> For some reason the SQL agent under server management does not restart ... Only problem is when the SQL server ...
    (microsoft.public.sqlserver.server)
  • Cmd line run problem as windows schedule
    ... SQL 2000, WIN 2000 Server ... I have a SQL cmd batch file, where I invoke a DTS package to ... I have a schedule job with windows scheduler where shows job runs and reslt ...
    (microsoft.public.sqlserver.programming)
Loading