Re: Scheduled Backup for SQL Database

From: Peter Yeoh (nospam_at_nospam.com)
Date: 09/30/04 

Date: Thu, 30 Sep 2004 18:22:08 +0800

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: SBS2003, NTBackup-Fehler
    ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • SQL/ MS 2003 server backups/restores
    ... I'm a bit confused on the backup necessary for my SQL server running on MS ... system state, OS etc, and another for my SQL databases. ...
    (microsoft.public.sqlserver.server)
  • Re: VSS event 6013
    ... I am experiencing a similar issue where VSS tries to access my SQL ... Server every time I perform a system state backup. ...
    (microsoft.public.windows.server.sbs)
  • Re: Performance Questions - disks
    ... SQL Server 2000 Performance Turning Technical Reference ISBN 0-7356-1270-6 ... %disk time is rather high and so is disk queue length. ... > backup files and deleting old backup files. ...
    (microsoft.public.sqlserver.server)