Re: Scheduled Backup for SQL Database

From: Peter Yeoh (nospam_at_nospam.com)
Date: 10/01/04 

Date: Fri, 1 Oct 2004 09:24:14 +0800

>> I have set the propeties on the SQL Agent to restart after 10 minutes
and the service does restart ok.
>> For some reason the SQL agent under server management does not restart
so the job fails.

I do not quite understand the above two (conflicting) statements. I guess
the SQL Agent service is restarting, but the job is not running. Is it
because the job is not scheduled to run at that time? 

-- 
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files?  Use MiniSQLBackup Lite, free!
<anonymous@discussions.microsoft.com> wrote in message
news:0b2801c4a6f6$21d26a20$a301280a@phx.gbl...
> Ok have nearly sorted it out. I Hope!
>
> I have managed to get the job to run by doing a database
> maintainance job going. This starts automatically and
> runs when scheduled. Only problem is when the SQL server
> shuts down it stops the agent. When the server restarts
> it doesn't restart the agent. I have set the propeties on
> the SQL Agent to restart after 10 minutes and the service
> does restart ok.
>
> For some reason the SQL agent under server management
> does not restart so the job fails. As soon as I right
> click and say start the job runs ok. So my question is
> Why doesn't this restart when the service does?
>
> Chris
> >-----Original Message-----
> >Any error messages for the job?  Look in the SQL Server
> log too, usually
> >found in the \Log subfolder of SQL Server.
> >
> >-- 
> >Peter Yeoh
> >http://www.yohz.com
> >Need smaller SQL2K backup files?  Use MiniSQLBackup
> Lite, free!
> >
> >
> ><anonymous@discussions.microsoft.com> wrote in message
> >news:42e701c4a6d0$7ccaf260$a501280a@phx.gbl...
> >> Yes they are both started by local administrator and
> the
> >> local administrator owns the backup job as well
> >> >-----Original Message-----
> >> >Is the SQL Server Agent service startup account the
> same
> >> account as the SQL
> >> >Server service?
> >> >
> >> >-- 
> >> >Peter Yeoh
> >> >http://www.yohz.com
> >> >Need smaller SQL2K backup files?  Use MiniSQLBackup
> >> Lite, free!
> >> >
> >> >
> >> ><anonymous@discussions.microsoft.com> wrote in message
> >> >news:45ec01c4a634$9c1441e0$a301280a@phx.gbl...
> >> >> Hi,
> >> >>
> >> >> The backup is just running to another drive on the
> same
> >> >> machine. My nightly backup routine goes and copies
> that
> >> >> directory to the central server for nightly backup
> >> >> >-----Original Message-----
> >> >> >Hi
> >> >> >
> >> >> >Make sure that the agent is running on a domain
> >> account
> >> >> that has access to
> >> >> >the other server. Are you
> >> >> using '\\machinename\sharename\file.bak' (UNC path)
> >> >> >as your naming standard for the backup file?
> >> >> >
> >> >> >You can not make a maintenance plan that uses a UNC
> >> >> share, so you have to
> >> >> >code it manually and setup a job (see BOL for
> BACKUP
> >> >> DATABASE).
> >> >> >
> >> >> >Cheers
> >> >> >Mike
> >> >> >
> >> >> >"Chris" wrote:
> >> >> >
> >> >> >> Hi All,
> >> >> >>
> >> >> >> Very new user to SQL admin. I need to backup a
> sql
> >> >> >> database, when I run it manually it runs fine and
> >> >> creates
> >> >> >> a backup without any issue. However when I try to
> >> >> >> schedule the job it does not save the schedule or
> >> run
> >> >> the
> >> >> >> backup.
> >> >> >>
> >> >> >> I am using Windows 2000 Server and SQL2000. Both
> are
> >> >> >> fully patched and have latest service packs.
> >> >> >>
> >> >> >> Am I doing something wrong or is this a bug. The
> SQL
> >> >> >> agent is running on the local machine, and the
> job
> >> >> >> appears in the backup list but always fails. I am
> >> >> trying
> >> >> >> to write to another data disk on the server with
> the
> >> >> >> routine to overwrite the file everytime.
> >> >> >>
> >> >> >> Any help would be great
> >> >> >>
> >> >> >.
> >> >> >
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages

  • Re: SQL Server and Reboot SBS
    ... The server only restarts when trying to start SQL after a manual stop/start ... A critical system process, C:\WINDOWS\system32\lsass.exe, failed with status ... The process winlogon.exe has initiated the restart of computer SBS on behalf ...
    (microsoft.public.windows.server.sbs)
  • 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: SQL Server 2000 and Service Account Password
    ... you are going to restart the service after changing the password ... We have several SQL 2000 servers running on Windows 2000 and Windows ... We were planning on changing the AD account password and then going to ... Do we need to restart SQL Server after we change the ...
    (microsoft.public.sqlserver.security)
  • Re: Scheduled DB Backup Never Executed, Why? Why?
    ... Please check whether your "SQL Agent" service in SQL ... Server service.This will probably solve your issue ... I used Enterprise Manager to schedule weekly local ...
    (microsoft.public.sqlserver.server)