Yes, a query like below should return all of the fileid's for the files stored
on volume 'z'. YMMV on mysql.
These are the fileid's to delete from the file table. After that, you'll need
to delete the rows from the jobmedia table associated with the volume.
SELECT f.fileid
FROM file f
LEFT
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 backed up on the media
associated with the job.
I found this query that you commented on:
http://adsm.o
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
> On Thu, 07 Aug 2014 15:14:42 -0400, John Wallach said:
>
> Hi Martin,
>
> I tried this after backi
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...
>8. Re: List files associated with destroyed tape (Martin Simmons)
--
John Wallach
Systems Administrator
> On Wed, 06 Aug 2014 12:37:57 -0400, John Wallach said:
>
> On 8/6/14 12:33 PM, Dan Langille wrote:
> >
> > Does this help?
> >
> > http://dan.langille.org/2009/08/28/what-jobs-are-on-these-tapes/
> >
>
> Thanks for the suggestion but I already know the media that is lost, I
> guess I cou
> It’s hard to extrapolate sometimes. See other email.
>
> The above [unasked] question is not what you originally asked, but
> I understand the concern.
>
> I’m not sure of the answer though. It would be a great trial&error
> task.
>
> If you can, try it on non-critial data instead. I’m in
On Aug 6, 2014, at 12:37 PM, John Wallach wrote:
> On 8/6/14 12:33 PM, Dan Langille wrote:
>>
>> Does this help?
>>
>> http://dan.langille.org/2009/08/28/what-jobs-are-on-these-tapes/
>>
>
> Thanks for the suggestion but I already know the media that is lost, I
> guess I could purge the volu
On Aug 6, 2014, at 12:11 PM, John Wallach wrote:
> 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 out how to find the files associa
On 8/6/14 12:33 PM, Dan Langille wrote:
>
> Does this help?
>
> http://dan.langille.org/2009/08/28/what-jobs-are-on-these-tapes/
>
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
On Aug 6, 2014, at 12:11 PM, John Wallach wrote:
> 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 out how to find the files associa
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 out how to find the files associated with the specific
media. Here's a query that I thought would w
11 matches
Mail list logo
