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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users