Arno Lehmann wrote:
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 for the reply, Arno. I had a thought....
My current Storage (with new Media Type) looks like this:
Storage {
Name = ThecusSoftwareDevFile
Address = pluto.waldo.home
SDPort = 9103
Password = "xxx"
Device = ThecusSoftwareDevStorage
Media Type = ThecusSoftwareDevFileMediaType
}
What if I add another Storage like this:
Storage {
Name = ThecusSoftwareDevFileOld
Address = pluto.waldo.home
SDPort = 9103
Password = "xxx"
Device = ThecusSoftwareDevStorage
Media Type = File
}
Would bacula then be able to find the previous types with the old Media
Type of File? My thought is that the new Storage directive could be
kept around until all of the backups with Media Type File have been
reclaimed. Feel free to call me totally crazy, I just don't relish
mucking with the DB if I don't have to... Thanks!
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
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
