Re: [Bacula-users] Help prunning oldest jobs

2009-11-20 Thread Martin Simmons
> On Thu, 19 Nov 2009 17:05:19 -0500, ReynierPM  said:
> 
> Hi every:
> I need to free some space in the HDD where I make backups. So I want to 
> delete some oldest volumes. I run this:
> 
> *status
> Status available for:
>   1: Director
>   2: Storage
>   3: Client
>   4: All
> Select daemon type for status (1-4): 3
> Automatically selected Client: FD.10.128.50.4
> Connecting to Client FD.10.128.50.4 at 10.128.50.4:9102
> 
> salvasprod_dc_hosting1-fd Version: 2.4.4 (28 December 2008) 
> i486-pc-linux-gnu debian 5.0
> Daemon started 03-Nov-09 09:10, 0 Jobs run since started.
>   Heap: heap=135,168 smbytes=9,502 max_bytes=9,624 bufs=52 max_bufs=53
>   Sizeof: boffset_t=8 size_t=4 debug=0 trace=0
> 
> Running Jobs:
> Director connected at: 19-Nov-09 17:03
> No Jobs running.
> 
> 
> Terminated Jobs:
>   JobId  LevelFiles  Bytes   Status   FinishedName
> ==
>1755  Full 26,54537.86 M  OK   06-Sep-09 02:10 
> SP_DC_Hosting1-FD
>1857  Incr 11,32037.60 M  OK   16-Sep-09 02:05 
> SP_DC_Hosting1-FD
>1908  Incr7812.055 M  OK   17-Sep-09 02:05 
> SP_DC_Hosting1-FD
>2217  Incr  8,32821.84 M  OK   23-Sep-09 03:23 
> SP_DC_Hosting1-FD
>2321  Incr3923.323 M  OK   25-Sep-09 02:04 
> SP_DC_Hosting1-FD
>2630  Incr9002.499 M  OK   01-Oct-09 03:23 
> SP_DC_Hosting1-FD
>2685  Incr3112.885 M  OK   02-Oct-09 03:30 
> SP_DC_Hosting1-FD
>3201  Incr70827.98 M  OK   12-Oct-09 03:40 
> SP_DC_Hosting1-FD
>3254  Incr  1,7935.485 M  OK   13-Oct-09 03:49 
> SP_DC_Hosting1-FD
>3307  Incr5872.094 M  OK   14-Oct-09 03:45 
> SP_DC_Hosting1-FD
> 
> 
> Now how I prune some of this jobs? Wich is the right command?

The "Terminated Jobs" listing above is not useful for this.

Use the "list jobs" command to see what is still in the catalog and the
"prune" or "purge" commands to remove jobs.

After doing that, if you want to delete the volumes from disk, then use the
"delete" command to remove the volume from the catalog before deleting it from
disk (e.g. with rm).

__Martin

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Help prunning oldest jobs

2009-11-20 Thread ReynierPM
Martin Simmons wrote:
> The "Terminated Jobs" listing above is not useful for this.
> 
> Use the "list jobs" command to see what is still in the catalog and the
> "prune" or "purge" commands to remove jobs.
> 
> After doing that, if you want to delete the volumes from disk, then use the
> "delete" command to remove the volume from the catalog before deleting it from
> disk (e.g. with rm).
> 

I'm a bit confuse at this point. Wich are the steps to follow? I mean 
for example:
1. List media
2. Prune (prune expired records from catalog)
2. Purge (purge records from catalog)
3. Delete
Is that right or I miss something?
Cheers

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Error while trying to prune a Volume

2009-11-20 Thread ReynierPM
Hi every:
I'm trying to prune oldest volumes using bwx-console from the Windows 7 
PC at my work. When I execute the command "prune volume" a windows is 
showed asking me for Pool. I pick the Pool and then another windows 
appear but this time asking for "Media Id" or "Volume Name". If I write 
the mediaid for example 33 (wich exists) I get this error:

sql_get.c:1030 Media record for Volume "33" not found.

See the entire output:

#prune volume
Defined Pools:
  1: CatalogoPool
  2: SP_Catalog_Pool
  3: SP_F04_Banco_Pool
  4: SP_F07_Aps_02_Pool
  5: SP_F02_Kainos_Pool
  6: SP_F07_RIS_01_Pool
  7: SP_DC_Hosting1_Pool
  8: SP_F05_Cneuro_Jonline_Pool
  9: SP_F03_SIGESPRO_Pool
 10: SP_F03_RNSVN_Pool
 11: SP_F05_POLO_RV_Pool
 12: SP_F07_RIS_02_Pool
 13: SP_F08_CICPC_Pool
 14: SP_F01_FTC_Pool
 15: SP_F01_SICI_Pool
 16: SP_F04_Aduana_01_Pool
 17: SP_F04_Aduana_02_Pool
 18: SP_F07_SE_01_Pool
 19: SP_F07_SE_02_Pool
 20: SP_DC_MonitoringServer_Pool
 21: SP_F02_IMAC_Pool
 22: SP_DC_PostgreSQL_Pool
 23: SP_F02_SVN_Pool
 24: SP_F08_POLO_SWE_Pool
 25: SP_F04_Sigep_01_Pool
 26: SP_F04_Sigep_02_Pool
 27: SP_F05_Pool
 28: SP_F08_Servers_Pool
 29: SP_F03_Fiscalia_Pool
 30: SP_DSL_Pool
 31: SP_F05_POLO_Hardware_Automatica_Pool
 32: SP_F03_Tribunales_Pool
 33: SP_F02_Alfresco_Pool
 34: SP_F03_RNVSS_Pool
 35: SP_F06_POLO_BIOINFORMATICA_Pool
 36: SP_F07_Aps_01_Pool
 37: SP_F07_HIS_Pool
 38: SP_SalvasProd_Pool
 39: SP_F10_Pool
 40: SP_Centaladad_Pool
 41: SP_CD_Consultoria_Pool
 42: SP_ERP_Pool
 43: P.10.128.50.4
 44: SP_DC_SVN_Pool
 45: SP_SVEXPBD01_Pool
 46: SP_SVEXPBD01_PgSQL_Pool
 47: SP_SVEXPBD02-Pool
 48: SP_SVEXPAPP01-Pool
 49: SP_SVEXPAPP02-Pool
 50: SP_SVEXPAPP08-Pool
 51: SP_F09_Pool
 52: SP_F09_POLO_PetroSoft_Pool
 53: SP_F09_POLO_GeoInformatica_Pool
 54: SP_F09_POLO_VideoSonidoDigital_Pool
 55: SP_F09_STA_Pool
Select the Pool (1-55): Unexpected question has been received.
7
+-+---+---+-+-+--+--+-+--+---+---+-+
| mediaid | volumename| volstatus | enabled | volbytes 
   | volfiles | volretention | recycle | slot | inchanger | mediatype | 
lastwritten |
+-+---+---+-+-+--+--+-+--+---+---+-+
|  33 | SP_DC_Hosting1_Pool-0033  | Used  |   1 | 
6,168,826 |0 |   63,072,000 |   1 |0 | 0 | File 
  | 2009-06-20 23:41:50 |
|  34 | SP_DC_Hosting1_Pool-0034  | Used  |   1 | 
720 |0 |   63,072,000 |   1 |0 | 0 | File  | 
2009-06-22 02:00:01 |
|  47 | SP_DC_Hosting1_Pool-0047  | Used  |   1 | 
31,610,842 |0 |   63,072,000 |   1 |0 | 0 | File 
  | 2009-06-23 02:00:08 |
|  56 | SP_DC_Hosting1_Pool-0056  | Used  |   1 | 
2,722,958 |0 |   63,072,000 |   1 |0 | 0 | File 
  | 2009-06-24 02:00:01 |
|  58 | SP_DC_Hosting1_Pool-0058  | Used  |   1 | 
583,616 |0 |   63,072,000 |   1 |0 | 0 | File 
| 2009-06-25 04:36:05 |
|  67 | SP_DC_Hosting1_Pool-0067  | Used  |   1 | 
3,088,131 |0 |   63,072,000 |   1 |0 | 0 | File 
  | 2009-06-26 02:00:02 |
|  70 | SP_DC_Hosting1_Pool-0070  | Used  |   1 | 
187,772 |0 |   63,072,000 |   1 |0 | 0 | File 
| 2009-06-27 02:00:01 |
|  71 | SP_DC_Hosting1_Pool-0071  | Used  |   1 | 
25,370,091 |0 |   63,072,000 |   1 |0 | 0 | File 
  | 2009-06-28 02:00:06 |
|  73 | SP_DC_Hosting1_Pool-0073  | Used  |   1 | 
28,645 |0 |   63,072,000 |   1 |0 | 0 | File 
   | 2009-06-29 02:00:01 |
|  82 | SP_DC_Hosting1_Pool-0082  | Used  |   1 | 
22,569,863 |0 |   63,072,000 |   1 |0 | 0 | File 
  | 2009-06-30 02:05:05 |
|  91 | SP_DC_Hosting1_Pool-0091  | Used  |   1 | 
5,435,756 |0 |   63,072,000 |   1 |0 | 0 | File 
  | 2009-07-02 02:05:47 |
|  98 | SP_DC_Hosting1_Pool-0098  | Used  |   1 | 
21,190 |0 |   63,072,000 |   1 |0 | 0 | File 
   | 2009-07-03 02:05:39 |
| 104 | SP_DC_Hosting1_Volume_000 | Append|   1 | 
208,966,577 |0 |   63,072,000 |   1 |0 | 0 | 
File  | 2009-10-14 03:45:16 |
+-+---+---+-+-+--+--+-+--+---+---+-+
Enter *MediaId or Volume name: Unexpected question has been received.
33
sql_get.c:103

Re: [Bacula-users] Help prunning oldest jobs

2009-11-20 Thread Martin Simmons
> On Fri, 20 Nov 2009 09:27:13 -0500, ReynierPM  said:
> 
> Martin Simmons wrote:
> > The "Terminated Jobs" listing above is not useful for this.
> > 
> > Use the "list jobs" command to see what is still in the catalog and the
> > "prune" or "purge" commands to remove jobs.
> > 
> > After doing that, if you want to delete the volumes from disk, then use the
> > "delete" command to remove the volume from the catalog before deleting it 
> > from
> > disk (e.g. with rm).
> > 
> 
> I'm a bit confuse at this point. Wich are the steps to follow? I mean 
> for example:
> 1. List media
> 2. Prune (prune expired records from catalog)
> 2. Purge (purge records from catalog)
> 3. Delete
> Is that right or I miss something?

Sorry, there is no simple sequence of steps, because it depends on which jobs
you want to keep.

If you already know which jobs and volumes you want to delete, then use the
"delete volume" command, which deletes all jobs on a volume and removes the
volume from the catalog.  Then use rm to delete the file.

In other cases, you can use the "prune volume" command and then use "list
volumes" to find any Purged volumes, which can be deleted.

__Martin

--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] backup for a new machine way too small

2009-11-20 Thread Toni Mueller


Hi,

I just added a new machine to my backup set and tried to run a full
backup. The machine is basically configured like any other, in terms of
what Bacula has to say, but the "compression ratio" was _much_ too good
to be true (~250MB instead of 3 GB, most of it being images). Bacula
claimed that the backup ran OK.

My backups go to disk, with one job = one file, roughly named
"__".

I didn't manage to find out what files are actually in a given backup
file, like outlined above. It would be sufficient for me to be able to
use something like 'restore' from the ufsdump package, but I didn't
find my way around 'bconsole' to achieve something similar. I also
tried 'bat', but when I clicked on what I thought was the FileSet
explorer (?), it simply hung after some 15-20 minutes (?), with
three windows in solid grey (no buttons, diagrams, nothing).

These are two Debian/Lenny machines with bacula 2.4.4.


Kind regards,
--Toni++


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] backup for a new machine way too small

2009-11-20 Thread Bruno Friedmann
Toni Mueller wrote:
> 
> Hi,
> 
> I just added a new machine to my backup set and tried to run a full
> backup. The machine is basically configured like any other, in terms of
> what Bacula has to say, but the "compression ratio" was _much_ too good
> to be true (~250MB instead of 3 GB, most of it being images). Bacula
> claimed that the backup ran OK.
> 
> My backups go to disk, with one job = one file, roughly named
> "__".
> 
> I didn't manage to find out what files are actually in a given backup
> file, like outlined above. It would be sufficient for me to be able to
> use something like 'restore' from the ufsdump package, but I didn't
> find my way around 'bconsole' to achieve something similar. I also
> tried 'bat', but when I clicked on what I thought was the FileSet
> explorer (?), it simply hung after some 15-20 minutes (?), with
> three windows in solid grey (no buttons, diagrams, nothing).
> 
> These are two Debian/Lenny machines with bacula 2.4.4.
> 
> 
> Kind regards,
> --Toni++
Hi Toni, I think your right about the compression.

Find your way as like this
bconsole
restore
choose choice 5
select your client
and it will build the tree backuped.
so you can navigate inside to see what's have been saved without really restore 
data.
cd ls etc .. are your friends

-- 

 Bruno Friedmann


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] backup for a new machine way too small

2009-11-20 Thread Bruno Friedmann
Forget to say that if your image are uncompressed tif for example they can be 
compressed 10/12 times.
So 3GB could become something aroud 300MB ...

Toni Mueller wrote:
> 
> Hi,
> 
> I just added a new machine to my backup set and tried to run a full
> backup. The machine is basically configured like any other, in terms of
> what Bacula has to say, but the "compression ratio" was _much_ too good
> to be true (~250MB instead of 3 GB, most of it being images). Bacula
> claimed that the backup ran OK.
> 
> My backups go to disk, with one job = one file, roughly named
> "__".
> 
> I didn't manage to find out what files are actually in a given backup
> file, like outlined above. It would be sufficient for me to be able to
> use something like 'restore' from the ufsdump package, but I didn't
> find my way around 'bconsole' to achieve something similar. I also
> tried 'bat', but when I clicked on what I thought was the FileSet
> explorer (?), it simply hung after some 15-20 minutes (?), with
> three windows in solid grey (no buttons, diagrams, nothing).
> 
> These are two Debian/Lenny machines with bacula 2.4.4.
> 


-- 

 Bruno Friedmann


--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users