Re: [Bacula-users] how to backup only the latest file of a daily sql backup
On 02/12/11 03:11, J. Echter wrote: > Hi, > > 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 :) Suggestion: Skin the cat a different way. Dump your Catalog each day to a SQL file, as you are doing now. Each day, BEFORE you dump the catalog, move the previous day's dump into a subdirectory which is not backed up. Problem solved, in five minutes of shell scripting. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, Free Stater It's not the years, it's the mileage. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] how to backup only the latest file of a daily sql backup
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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] how to backup only the latest file of a daily sql backup
Am 12.02.2011 09:11, schrieb J. Echter: > Am 12.02.2011 08:57, schrieb Jan Lentfer: >> Hi Jürgen, >> >> Am 12.02.2011 08:29, schrieb J. Echter: >>> can anybody tell me how to handle this? >>> >>> what i have: >>> >>> - a daily backup of a sql db >>> - the backup files are kept 14 days on the server itself >>> - i want to backup only the newest file to tape >>> >>> files are called, for example: >>> >>> sql_backup_2011_02_07_230003_9327174.bak >>> >>> the reason for this is, my tapes running out of space... :) >>> >>> backups are 35 gb, i could save ~30 gb. >>> >>> 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?!?! >> >> Jan >> > Hi, > > 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 :) additionaly: we backup on a daily tape rotation basis, doing fulls on tape. > greetings > > juergen. > -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] how to backup only the latest file of a daily sql backup
Am 12.02.2011 08:57, schrieb Jan Lentfer: > Hi Jürgen, > > Am 12.02.2011 08:29, schrieb J. Echter: >> can anybody tell me how to handle this? >> >> what i have: >> >> - a daily backup of a sql db >> - the backup files are kept 14 days on the server itself >> - i want to backup only the newest file to tape >> >> files are called, for example: >> >> sql_backup_2011_02_07_230003_9327174.bak >> >> the reason for this is, my tapes running out of space... :) >> >> backups are 35 gb, i could save ~30 gb. >> >> 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?!?! > > Jan > Hi, 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 :) greetings juergen. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] how to backup only the latest file of a daily sql backup
Hi Jürgen, Am 12.02.2011 08:29, schrieb J. Echter: > can anybody tell me how to handle this? > > what i have: > > - a daily backup of a sql db > - the backup files are kept 14 days on the server itself > - i want to backup only the newest file to tape > > files are called, for example: > > sql_backup_2011_02_07_230003_9327174.bak > > the reason for this is, my tapes running out of space... :) > > backups are 35 gb, i could save ~30 gb. > > 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?!?! Jan -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users