Author: John Wallach <john AT democracynow DOT org>
Date: Wed, 06 Aug 2014 12:11:25 -0400
Greetings, Our ancient autoloader decided to render a particular tape inoperable. Before my time jobs were run that spanned multiple volumes, the destroyed tape was in one such job. I cannot figure o
Does this help? http://dan.langille.org/2009/08/28/what-jobs-are-on-these-tapes/ Dan Langille Attachment: signature.asc Description: Message signed with OpenPGP using GPGMail -- Infragistics Professi
Author: John Wallach <john AT democracynow DOT org>
Date: Wed, 06 Aug 2014 12:37:57 -0400
Thanks for the suggestion but I already know the media that is lost, I guess I could purge the volume but I wonder what what that would do to the job (since it has files on other volumes.) -- John Wa
SELECT t3.Path, t1.Name FROM Filename AS FN JOIN File as F ON FN.FilenameId = F.FilenameId JOIN Path as P ON P.PathId = F.PathId JOIN JobMedia as JB ON F.JobId = JB.JobId WHERE JB.MediaId = 475 AND F
Its hard to extrapolate sometimes. See other email. The above [unasked] question is not what you originally asked, but I understand the concern. Im not sure of the answer though. It would be a great
Author: John Wallach <john AT democracynow DOT org>
Date: Wed, 06 Aug 2014 13:09:26 -0400
Sorry for being unclear about what I am attempting. I might make backup of catalog, query for all files associated with job then purge the volume and run same query and diff for results. But I disli
Author: Martin Simmons <martin AT lispworks DOT com>
Date: Wed, 6 Aug 2014 18:49:29 +0100
Purging the volume will delete all of its jobs from the catalog, so the records for the other volumes will be updated appropriately. __Martin -- Infragistics Professional Build stunning WinForms app
Author: John Wallach <john AT democracynow DOT org>
Date: Thu, 07 Aug 2014 15:14:42 -0400
Hi Martin, I tried this after backing up the catalog. It worked in the sense that it purged the files from the destroyed media but it also purged all the rest of the files in the job... -- John Walla
Author: Martin Simmons <martin AT lispworks DOT com>
Date: Fri, 8 Aug 2014 12:05:44 +0100
Yes, that's what I expected -- purging a volume deletes its jobs from the database. Leaving part of a job in the database would be dangerous because a restore would be incomplete. __Martin -- Want fa
Author: John Wallach <john AT democracynow DOT org>
Date: Fri, 08 Aug 2014 07:41:27 -0400
Ah, That makes a lot of sense from a preservation of the jobs that's the best behavior, however we've shoehorned bacula into an archiving system so I don't want to lose access to the other data backe
Author: Martin Simmons <martin AT lispworks DOT com>
Date: Fri, 8 Aug 2014 17:55:35 +0100
Yes, a query like below should return all of the fileid's for the files stored on volume 'zzzzz'. YMMV on mysql. These are the fileid's to delete from the file table. After that, you'll need to delet