Re: Scheduled Backup for SQL Database
anonymous_at_discussions.microsoft.com
Date: 09/30/04
- Next message: Russell: "Re: Trailing spaces padding out cells?"
- Previous message: paldba: "Re: Dump Transaction With Truncate Only"
- In reply to: Peter Yeoh: "Re: Scheduled Backup for SQL Database"
- Next in thread: Peter Yeoh: "Re: Scheduled Backup for SQL Database"
- Reply: Peter Yeoh: "Re: Scheduled Backup for SQL Database"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Sep 2004 07:02:33 -0700
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
>> >> >>
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Russell: "Re: Trailing spaces padding out cells?"
- Previous message: paldba: "Re: Dump Transaction With Truncate Only"
- In reply to: Peter Yeoh: "Re: Scheduled Backup for SQL Database"
- Next in thread: Peter Yeoh: "Re: Scheduled Backup for SQL Database"
- Reply: Peter Yeoh: "Re: Scheduled Backup for SQL Database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
