On Jan 31, 2013, at 7:58 AM, Uwe Schuerkamp wrote: > Hello list, > > is it possible to delete several bacula volumes in one go, say like > so: > > delete catalog=MyCatalog volume=v01 volume=vol2 ... yes ?
Script it. echo 'catalog=MyCatalog volume=v01 yes' | console I'm assuming you know how to get a list of those volumes into a script… > I have several volumes with sizes in the hundreds of gigabytes and I > assume that deleting them or rather their corresponding file table > entries in one fell swoop (single delete from sql statement) would be > faster then deleting them one by one (which takes several hours per > volume on a 200GB file table with nearly one billion rows). Why does it take several hours per volumes to delete a volume? You're just acting on the Catalog. Oh yes, deleting all the file and job references. Well, perhaps we need to look at that took The database is lacking in referential integrity. I wish it wasn't. By rights, you should be able to go in and delete from the media table, and have everything be safe and sound. i.e. no orphans. But that's not the case, last time I checked. So.. yeah, be cautious there. Sooner or later, you're going to have to let those records get deleted. -- Dan Langille - http://langille.org ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_jan _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
