>>>>> On Mon, 19 Jul 2010 16:06:27 +0100, Rory Campbell-Lange said:
> 
> As part of our intended audit process of a backup set we'd like to
> extract a file from each tape from which a backup set is composed.
> 
> Is there a way of learning which tape holds a particular file (or
> vice-versa)? I assume this is how retrievals work, but it isn't that
> obvious in the database schema (I'm using Postgres):
> 
> \d File
>        Column   |  Type   
>     ------------+---------
>      fileid     | bigint   (Primary Key)
>      fileindex  | integer  (File sequence number in job)
>      jobid      | integer  (Link to Job Record)
>      pathid     | integer  (Link to Path Record)
>      filenameid | integer  (Link to Filename Record)
>      markid     | integer  (Used to mark files during Verify Jobs)
>      lstat      | text     (attributes in base64 encoding)
>      md5        | text     (MD5 signature in base64 encoding)
> 
> I can get from File back to Filename and Path, and from File to Job. It isn't
> clear how one gets from there to Media.
> 
> What is the SQL relationship from the File table to the Media table?

The JobMedia table is used to map from jobid + fileindex to mediaid +
(tape-)file + (tape-)block.

__Martin

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users