Pour infos, le dernier ordre sql ( buildind tree ) emis lors d'un
restore->choix 5 sous la console :
SELECT Path.Path, Filename.Name, File.FileIndex, File.JobId, File.LStat
FROM ( SELECT max(FileId) as FileId, PathId, FilenameId
FROM ( SELECT FileId, PathId, FilenameId
FROM File
WHERE JobId IN (4032,4072))
AS F GROUP BY PathId, FilenameId )
AS Temp JOIN Filename ON (Filename.FilenameId = Temp.FilenameId)
JOIN Path ON (Path.PathId = Temp.PathId)
JOIN File ON (File.FileId = Temp.FileId) WHERE File.FileIndex > 0
ORDER BY JobId, FileIndex ASC
A+
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Bacula-users-fr mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users-fr
