> > Can someone point me to the relationship between Media and File?
> 
> Compare File.FileIndex to JobMedia.FirstIndex and JobMedia.LastIndex.
> 
> The JobMedia.StartFile and JobMedia.EndFile columns record the "tape file",
> i.e. EOF marks on the tape that are used for fast seeking.

    bacula=# select distinct(jobid), min(fileid), max(fileid) from file group 
by jobid;
     jobid |   min    |   max    
    -------+----------+----------
         1 |        1 |  7706717
         2 |  7706718 |  7706718
         3 |  7706719 |  7706719
         4 |  7706720 |  7706720
         8 | 11669603 | 15635109
         9 | 15635110 | 16908568
        10 | 16908569 | 16908569
        11 | 16908570 | 16908570
        13 | 16908571 | 16908571
        17 | 16908572 | 16908572
        19 | 16908573 | 16908573

    bacula=# select distinct(jobid), min(firstindex), max(lastindex) from 
jobmedia group by jobid;
     jobid | min |   max   
    -------+-----+---------
         1 |   1 | 7706717
         2 |   1 |       1
         3 |   1 |       1
         4 |   1 |       1
         8 |   0 | 3965507
         9 |   1 | 1273459
        10 |   1 |       1
        11 |   1 |       1
        13 |   1 |       1
        17 |   1 |       1
        19 |   1 |       1

This shows that each backup starts from 1 (0 for one of them?!), so there is no
direct relationship between the jobmedia and file tables. Correct?

-- 
Rory Campbell-Lange
rory AT campbell-lange DOT net

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users