Re: Growing Database problem,

From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 15:22:58 -0400

> Veritas 9 with SQL agents are there for backup. Come to think of it, would
> it be more worth performing a schedule to backup into *.bak file at say,
> 12am, with a 1am backup of the *.bak file?

As long as you are confident that your initial backup will always run in
under an hour. I can't say that with any certainty about any of my
systems... you never know what variables might change tomorrow. 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Relevant Pages

  • Re: Volume Shadow Copy on 2003 Server w/ SQL 2k SP3
    ... Backing up the mailstores with NT backup requires using the SQL agent. ... NT backup work most of the time, even when third party sql agents dont ... AFIK is for data files not databases. ...
    (NT-Bugtraq)
  • RE: SBS Backup Error 0X8007007A
    ... have you manually create a scheduled backup job using the ... NTBackup tool and see if the backup works. ... If the Task Scheduler service is not already running, ... schedule", ...
    (microsoft.public.windows.server.sbs)
  • Re: Data Protector 6.0 scheduling mysteries
    ... In our complex scenario with many hosts and devices, I wrote a backup ... As DP cannot schedule at 17:10, the backup was scheduled at 17:00 also. ... and data protection. ... The omnitrig process is what actually schedules the sessions, ...
    (comp.sys.hp.hpux)
  • Re: Scheduled backups fail to start
    ... the same as the backup tasks. ... Can you run this batch file as ... The backup job started on 07/10/2008 at 16.53.56.88. ... - When you scheduled your backup, ...
    (microsoft.public.windows.server.general)
  • Re: Data Protector 6.0 scheduling mysteries
    ... A to D are backup specifications and the first occurrences are incremental ... As DP cannot schedule at 17:10, the backup was scheduled at 17:00 also. ... Cron can do a better job for 20 years now. ... The omnitrig process is what actually schedules the sessions, ...
    (comp.sys.hp.hpux)