Re: [Bacula-users] Is it save to delete all Volumes with VolStatus = "Purged"?

2008-12-02 Thread Rodrigo Severo
On Tue, Dec 2, 2008 at 11:22 AM, Alan Brown <[EMAIL PROTECTED]> wrote:

> On Sat, 29 Nov 2008, Rodrigo Severo wrote:
>
> > Is it safe to delete all Volumes with VolStatus = "Purged"?
>
> Only if you do not plan to use them again.


Ok. That is what I understood. Thanks for your input.

I don't plan using them again as I backup to disks so each volume is a file
that should not be reused.


Thanks again,

Rodrigo Severo

-- 
---
Rodrigo Severo

Fábrica de Idéias
SBS Quadra 2 - Bloco S - Ed. Empire Center - Sala 1.301
Brasília - DF - CEP 70070-904
Tel. (61) 3321-1357   Fax (61) 3223-1712
---
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Is it save to delete all Volumes with VolStatus = "Purged"?

2008-12-02 Thread Alan Brown
On Sat, 29 Nov 2008, Rodrigo Severo wrote:

> Is it safe to delete all Volumes with VolStatus = "Purged"?

Only if you do not plan to use them again.

Volumes which are Purged exist in the database, but have no other records
associated with them.


-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


[Bacula-users] Is it save to delete all Volumes with VolStatus = "Purged"?

2008-11-29 Thread Rodrigo Severo
Hi,


Is it safe to delete all Volumes with VolStatus = "Purged"?

I ask because I have the following situation on my Bacula database right now:

> select VolStatus, count(MediaId) from Media group by VolStatus;
+---++
| VolStatus | count(MediaId) |
+---++
| Full  |  7 |
| Purged|  13469 |
| Error | 28 |
| Used  |333 |
+---++

I believe I can get rid of 13469 records of a 13837 records database.

Is there anything else I shoudl check before deleting these records?

And the way to delete all those Volumes would be:

DELETE FROM Media WHERE VolStatus = "Purged";

or is there a sane bconsole command that would do it?


TIA,

Rodrigo Severo

-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users