On Wednesday 30 May 2007 12:57:30 pm Jeronimo Zucco wrote: > Sometimes users remove files accidentally (or no) and after a long > time, they ask for admins to restore the last version of specified > file. Admins have to search one jobId in a lot of backups for a client > by try-error to find the last version of file. > > I suggest a restore option for solve this issue: > > - Select the most recent backup for a especified file for a client > > > Best regards,
There is a query in the query.sql file that should help you with that: from within bconsole: query 2 (Then follow the prompts.) It doesn't actually DO the restore, but it does identify what the latest file is and the volume it's written to. -- -- Flak Magnet (Tim) www.flakmagnet.com ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users