>>>>> On Wed, 18 Aug 2010 23:15:59 +0100, Rory Campbell-Lange said: > > > > 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?
No, you are still using the wrong columns. It should be min(fileindex), max(fileindex) in the first query. __Martin ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
