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
