Hi, 17.10.2007 14:31,, Paul Waldo wrote:: > Hi all, > > After quite a bit of churning on my issue about Storage directives and > restores, I have found the answer (thanks Vik!) I had all of the Media > Types for my many Storage directives set to "File". When I tried to > restore, bacula went to the first Storage directive with the appropriate > type, which was typically the wrong one.
Yes, that is a common result. > So, each of my storage directives now has a unique Media Type, such as > Share42FileMediaType. The problem now is that all of the previous > backups, while valid, are of the old Media Type (File). Now my daily > backups fail (or at least require intervention) with the message "Cannot > find any appendable volumes". I assume this is because the old Media > Type has been forgotten, and recycling cannot take place. Does this > seem reasonable? More or less... the old media type has not been forgotten, but there is no device left to use these volumes. > If this is indeed the case, it seems to me what I need to do is modify > the database so that File media types are changed to the correct media > types. Does this sound like a prudent thing to do? Definitely. > Is there a way to > do this within bacula, or do I need to do some SQL magic? I'd do this with bconsoles sqlquery command. You'll need to know your SQL commands, though... Just create a full database dump before you work on it. Then, SQL commands like 'update Media set MediType="whatever" where MediaId in (1, 2, 3);' should work. You'll need the list of MediaIds for each set of volumes, of course, but these can be found easily. Arno > Thanks in advance for any tips or pointers! > > Paul > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Bacula-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
