Bacula-users

Re: [Bacula-users] how to backup only the latest file of a daily sql backup

2011-02-12 05:03:10
Subject: Re: [Bacula-users] how to backup only the latest file of a daily sql backup
From: Jan Lentfer <Jan.Lentfer AT web DOT de>
To: "J. Echter" <j.echter AT elektro-mayer-echter DOT de>
Date: Sat, 12 Feb 2011 10:59:34 +0100
Am 12.02.2011 09:11, schrieb J. Echter:
> Am 12.02.2011 08:57, schrieb Jan Lentfer:
>> machine is a windows 7 x64.
>> I don't exactly get what you mean. If you dump daily to the same
>> directory and run incremental over that directory, only the dump of
>> the actual day should be backed up?!?!
> the problem is, i can't do a Full Backup of this. Reason is first tape
> would be full.
>
> i do full backups to disk, and also have fulls on the server. so i would
> need only the latest file on tape, just to be sure :)
hm.. without thinking about it too much, couldn't you dump into some 
temp directory with a generic name (not including timestamps or such), e.g.

/var/temp_dumps/sqldump.file

backup that directory and then move the file to your usual directory 
including the timestamp using, e.g.

/var/dumps/sqldump_20110212.file

using client run after job script?

You would need to exclude  /var/dumps from the usual backup then.

You a quick thought :)

Which DBMS is this anyway?

-- 
professional: http://www.oscar-consult.de
private: http://neslonek.homeunix.org/drupal/


------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users