Re: [Bacula-users] Best backup strategy to use the minimum size

2009-10-16 Thread Cedric Tefft
Jesper Krogh wrote: > Cedric wrote: > >> Do a Differential once every 90 days and Incrementals the rest of the time. >> In theory, you only need to run one Full backup. Ever. In practice, you'll >> probably want to create a new Full backup every year or so to clear out the >> obsolete data and m

Re: [Bacula-users] bextract -- restore single occurrence of file

2009-10-16 Thread Jesper Krogh
> I fired up bextract (standard bacula restore is not appropriate in this > case) which restored the first occurrence of the file as expected. However, > instead of halting after restoring the file, bextract continued to the end > of the tape and found a second occurrence with the same filename wh

Re: [Bacula-users] Best backup strategy to use the minimum size

2009-10-16 Thread Jesper Krogh
Cedric wrote: > Do a Differential once every 90 days and Incrementals the rest of the time. > In theory, you only need to run one Full backup. Ever. In practice, you'll > probably want to create a new Full backup every year or so to clear out the > obsolete data and make your differentials smaller

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Jesper Krogh
Nicola Quargentan wrote: > Jesper Krogh ha scritto: >> Nicola Quargentan wrote: >>> I'm very newbie and I want to use a DELL TL2000 autochanger. >>> I made 7 pool in config file, one for each day of week: >>> Monday, Tuesday, etc. >> Monday, Tuesday and so is mostly used when you dont have an autoc

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Jesper Krogh
> But the use of pools on what for? > Just for completeness I must save this data: > > 1) Oracle db (size unknown) > 2) 5-6 MySQL db (about 25 Gb) > 3) Some samba share, with office files (5Gb) > 4) An subversion reposity (size unknown) > 5) Mail server (size unknown) > 6) The configuration o

Re: [Bacula-users] Best backup strategy to use the minimum size

2009-10-16 Thread Cedric
On Fri, Oct 16, 2009 at 8:05 PM, Jose Perez wrote: > Hi people: > > I'm trying to find the best combination of Full, Differential and > Incremental backups to save disk space, I'd like someone can help me > with some ideas: > > Our policy says that we must keep user data of last 3 months, so > ac

[Bacula-users] Best backup strategy to use the minimum size

2009-10-16 Thread Jose Perez
Hi people: I'm trying to find the best combination of Full, Differential and Incremental backups to save disk space, I'd like someone can help me with some ideas: Our policy says that we must keep user data of last 3 months, so according to that I planned to do something like this: Client { ..

Re: [Bacula-users] sorting output bconsole

2009-10-16 Thread Jari Fredriksson
17.10.2009 2:19, Terry L. Inzauro kirjoitti: For testing, I've decided to use the mysql command line interface and I have one last question. How would I take take sums of two columns such as JobFiles and JobBytes [18:13:04 r...@jenna:~]# mysql -u root -px Welcome to the MySQL monitor. C

Re: [Bacula-users] Fwd: Tape Problems

2009-10-16 Thread João Kuchnier
Sorry, I though I was answering to all the list. The schedules will start on monday. If something goes wrong, I report to the list. João K. 2009/10/16 John Drescher : > Forwarding to the list so others can possibly answer.. > > > -- Forwarded message -- > From: João Kuchnier > D

[Bacula-users] Fwd: Tape Problems

2009-10-16 Thread John Drescher
Forwarding to the list so others can possibly answer.. -- Forwarded message -- From: João Kuchnier Date: Fri, Oct 16, 2009 at 7:10 PM Subject: Re: [Bacula-users] Tape Problems To: John Drescher I created the new pools but I had a problem.: "pool" directive in Job "BKP_Servido

Re: [Bacula-users] sorting output bconsole

2009-10-16 Thread Terry L. Inzauro
John Drescher wrote: > On Fri, Oct 16, 2009 at 6:30 PM, Terry L. Inzauro > wrote: >> John Drescher wrote: >>> On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro >>> wrote: Does bconsole support sorting of output? For instance, can bconsole sort the output of "list volumes pool=FullPoo

Re: [Bacula-users] Tape Problems

2009-10-16 Thread John Drescher
On Fri, Oct 16, 2009 at 7:10 PM, João Kuchnier wrote: > I created the new pools but I had a problem.: > > "pool" directive in Job "BKP_Servidor" resource is required, but not found. > > What pool I can configure here? I putted the pool configuration inside > Schedules. Like this: > > Schedule { >

Re: [Bacula-users] sorting output bconsole

2009-10-16 Thread John Drescher
On Fri, Oct 16, 2009 at 6:30 PM, Terry L. Inzauro wrote: > John Drescher wrote: >> On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro >> wrote: >>> Does bconsole support sorting of output?   For instance, can bconsole sort >>> the output of "list volumes pool=FullPool" by size >>> or date? >>> >>

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Nicola Quargentan
John Drescher ha scritto: >> I'm not fully persuased about bacula. I fear that the database (MySQL) >> become corrupted. >> > > That is why you should keep a copy of the database on a disk based > volume (or other backup) on a different machine than the one that > contains the database. > > I hav

Re: [Bacula-users] sorting output bconsole

2009-10-16 Thread Terry L. Inzauro
John Drescher wrote: > On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro > wrote: >> Does bconsole support sorting of output? For instance, can bconsole sort >> the output of "list volumes pool=FullPool" by size >> or date? >> >> kind regards, >> > > You can do that in a query. > > John Wh

Re: [Bacula-users] sorting output bconsole

2009-10-16 Thread Jose Perez
Hi: On Fri, Oct 16, 2009 at 4:03 PM, Terry L. Inzauro wrote: > Does bconsole support sorting of output?   For instance, can bconsole sort > the output of "list volumes pool=FullPool" by size > or date? > I don't think this is possible but you could some bash script to sort: -init of bconsol

Re: [Bacula-users] sorting output bconsole

2009-10-16 Thread John Drescher
On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro wrote: > Does bconsole support sorting of output?   For instance, can bconsole sort > the output of "list volumes pool=FullPool" by size > or date? > > kind regards, > You can do that in a query. John ---

[Bacula-users] sorting output bconsole

2009-10-16 Thread Terry L. Inzauro
Does bconsole support sorting of output? For instance, can bconsole sort the output of "list volumes pool=FullPool" by size or date? kind regards, Terry -- Come build with us! The BlackBerry(R) Developer Conference

Re: [Bacula-users] Tape Problems

2009-10-16 Thread John Drescher
On Fri, Oct 16, 2009 at 4:59 PM, João Kuchnier wrote: > I will test this settings as soon as I can. Thanks! > BTW, you can move your current tapes to the new pools (one by one) using update volume then choose Pool then select the current pool. then enter the id either by tape name or metaid. P

Re: [Bacula-users] Renaming volumes...

2009-10-16 Thread Bruno Friedmann
John Doe wrote: > Hi, > > I use a USB disk as storage and at first I had volumes labeled like this: > > Label Format = "${Client}.${Year}-${Month:p/2/0/r}.full.v${NumVols}" > Label Format = "${Client}.${Year}-${Month:p/2/0/r}.diff.v${NumVols}" > Label Format = "${Client}.${Year}-${Month:p/2

Re: [Bacula-users] Tape Problems

2009-10-16 Thread John Drescher
On Fri, Oct 16, 2009 at 3:44 PM, João Kuchnier wrote: > I will need create new schedules and jobs too write? One for each pool. > > No one schedule but one Run= for each day. For example: Schedule { Name = "MonthlyCycle" Run = Level=Full Pool=SundayPool sun at 2:05 Run = Level=Incremental P

Re: [Bacula-users] Tape Problems

2009-10-16 Thread John Drescher
On Fri, Oct 16, 2009 at 3:10 PM, João Kuchnier wrote: > Hi everyone! > > I having some problems with my backup planning. > > I want to work with five tapes per week. One for Monday, Tuesday, > Wednesday, Thursday and Friday. This five tapes will be used till the > end of the month. > > The problem

[Bacula-users] Tape Problems

2009-10-16 Thread João Kuchnier
Hi everyone! I having some problems with my backup planning. I want to work with five tapes per week. One for Monday, Tuesday, Wednesday, Thursday and Friday. This five tapes will be used till the end of the month. The problem is the following. The backup finished OK yesterday (Thursday). Later

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Arno Lehmann
Hi, 16.10.2009 18:45, Nicola Quargentan wrote: > Bob Hetzel ha scritto: ... >> Forget about trying to keep straight which tape is for which day and let >> bacula track that for you. When you need to do a restore, let bacula >> tell you which volumes that data is on. > > I'm not fully persuased

Re: [Bacula-users] Building bacula-fd on OpenBSD 4.5

2009-10-16 Thread Mike Erdely
Martin Simmons wrote: >> On Thu, 15 Oct 2009 07:34:57 -0300, Daniel Bareiro said: >> >> On Wednesday, 14 October 2009 17:38:59 +0100, >> Martin Simmons wrote: >> # DGB - 20091012 >> # Starting bacula-fd on boot >> if [ -x /etc/bacula/scripts/bacula-ctl-fd ]; then >> /etc/bacula/scripts/

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread John Drescher
On Fri, Oct 16, 2009 at 1:05 PM, Nicola Quargentan wrote: > John Drescher ha scritto: >> >> On Fri, Oct 16, 2009 at 12:17 PM, Nicola Quargentan >> wrote: >>> >>> Alex Chekholko ha scritto: > > cut... >> >> Okay. None of the tapes are in any pool. So now you really only want >> to use the label ba

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Nicola Quargentan
John Drescher ha scritto: > On Fri, Oct 16, 2009 at 12:17 PM, Nicola Quargentan > wrote: >> Alex Chekholko ha scritto: cut... > > Okay. None of the tapes are in any pool. So now you really only want > to use the label barcodes command > > and put all volumes in the Scratch pool. No need to speci

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread John Drescher
> I'm not fully persuased about bacula. I fear that the database (MySQL) > become corrupted. > That is why you should keep a copy of the database on a disk based volume (or other backup) on a different machine than the one that contains the database. I have most of my backups (> 25TB now) go to

[Bacula-users] brestore cache tables

2009-10-16 Thread P.A
Hi trying to get webrestore to work, so far I can see page clients but not jobs. I believe this is because I have no imported the bweb.sql. According to the install file its says, "3) Make sure that brestore cache tables are in your catalog (bweb-xxx.sql files)" How do I achieve this, I ran

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Nicola Quargentan
Bob Hetzel ha scritto: > Nicola, > > If you're using barcodes you can greatly simplify what you're doing. > Instead of using one pool per day, just use one pool for all backups and > one scratch pool. Place all the tapes in the scratch pool. Ok, now this is that I want. > > Forget about tryi

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread John Drescher
On Fri, Oct 16, 2009 at 12:17 PM, Nicola Quargentan wrote: > Alex Chekholko ha scritto: >> On Fri, 16 Oct 2009 16:52:21 +0200 >> Nicola Quargentan wrote: >> I just tested this and the "Select the Pool" must be the old pool. >>> But I haven't an old pool, I never associated a volume to a pool

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Nicola Quargentan
Alex Chekholko ha scritto: > On Fri, 16 Oct 2009 16:52:21 +0200 > Nicola Quargentan wrote: > >>> I just tested this and the "Select the Pool" must be the old pool. >> But I haven't an old pool, I never associated a volume to a pool (I hope). >> > > From your previous mail, it looks like when you

Re: [Bacula-users] Order of Install?

2009-10-16 Thread Alex Chekholko
On Fri, 16 Oct 2009 14:21:39 +0100 "Gabriel - IP Guys" wrote: > I've look at a number of guides, and as yet, none recommend an order to > install bacula in. Also, none recommend what is the best source to use, > packaged for the distro, or the source. I'm attempting to install on a > CentOS 5.3

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Nicola Quargentan
Jesper Krogh ha scritto: > Nicola Quargentan wrote: >> I'm very newbie and I want to use a DELL TL2000 autochanger. >> I made 7 pool in config file, one for each day of week: >> Monday, Tuesday, etc. > > Monday, Tuesday and so is mostly used when you dont have an autochanger. Oh you are right: be

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Alex Chekholko
On Fri, 16 Oct 2009 16:52:21 +0200 Nicola Quargentan wrote: > >> > > > > I just tested this and the "Select the Pool" must be the old pool. > > But I haven't an old pool, I never associated a volume to a pool (I hope). > >From your previous mail, it looks like when you did a "label barcodes"

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Nicola Quargentan
John Drescher ha scritto: > On Thu, Oct 15, 2009 at 7:48 PM, Nicola Quargentan > wrote: >> John Drescher ha scritto: >>> On Thu, Oct 15, 2009 at 6:03 PM, Nicola Quargentan >>> wrote: hi, I'm very newbie and I want to use a DELL TL2000 autochanger. I made 7 pool in config file,

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread John Drescher
> If you're using barcodes you can greatly simplify what you're doing. > Instead of using one pool per day, just use one pool for all backups and > one scratch pool.  Place all the tapes in the scratch pool. > BTW, I definitely agree with this. It's best not to have 1 pool per day if you do not re

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread John Drescher
On Thu, Oct 15, 2009 at 7:48 PM, Nicola Quargentan wrote: > John Drescher ha scritto: >> On Thu, Oct 15, 2009 at 6:03 PM, Nicola Quargentan >> wrote: >>> hi, >>> >>> I'm very newbie and I want to use a DELL TL2000 autochanger. >>> I made 7 pool in config file, one for each day of week: >>> Monday

Re: [Bacula-users] [Bacula-devel] VirtualFull backup: bacula selects the wrong read device

2009-10-16 Thread Nicolae Mihalache
Thanks a lot, I will switch to version 3.0.3 as soon as it is out. In the meanwhile I was running with the my modification and so far didn't have any trouble (but I'm not using bextract). nicolae Kern Sibbald wrote: > Hello, > > On Monday 12 October 2009 04:09:16 Nicolae Mihalache wrote: > >> I

[Bacula-users] Order of Install?

2009-10-16 Thread Gabriel - IP Guys
I've look at a number of guides, and as yet, none recommend an order to install bacula in. Also, none recommend what is the best source to use, packaged for the distro, or the source. I'm attempting to install on a CentOS 5.3 box fully updated. Any hints and tips will be appreciated. ---

Re: [Bacula-users] autochanger and barcode

2009-10-16 Thread Bob Hetzel
Nicola, If you're using barcodes you can greatly simplify what you're doing. Instead of using one pool per day, just use one pool for all backups and one scratch pool. Place all the tapes in the scratch pool. Forget about trying to keep straight which tape is for which day and let bacula trac

Re: [Bacula-users] [Bacula-devel] VirtualFull backup: bacula selects the wrong read device

2009-10-16 Thread Kern Sibbald
Hello, On Monday 12 October 2009 04:09:16 Nicolae Mihalache wrote: > I tried your change but VirtualFull with multiple read devices is not > working. Restore is working but it was working even without your change. Yes, I hadn't noticed one small important detail in your code :-( so my code didn'

[Bacula-users] Renaming volumes...

2009-10-16 Thread John Doe
Hi, I use a USB disk as storage and at first I had volumes labeled like this: Label Format = "${Client}.${Year}-${Month:p/2/0/r}.full.v${NumVols}" Label Format = "${Client}.${Year}-${Month:p/2/0/r}.diff.v${NumVols}" Label Format = "${Client}.${Year}-${Month:p/2/0/r}.incr.v${NumVols}" But,

Re: [Bacula-users] How to avoid "The sizes do not match!"?

2009-10-16 Thread Christian Gaul
epiuse schrieb: > Hi there, > > We're currently using bacula 3.0.2 to backup some windows XP and Vista > clients. > > Every now and then, while a backup (Diff or Full) are running, the user may > turn of his/her laptop, network issues may occur or whatever else may cause a > connection error and