[Bacula-users] SQL Query Copy Jobs show last Full

Hi guys,

I am currently trying to implement Copy Jobs into my Backup environemnt. I want to use SQL Query patterns as type of selction.

My idea is that I copy the LAST Full Backups of ALL Clients to Tape. Hence, since I am not familiar with the SQL commands so well, I am looking for support from your side for such a pattern

The only "rules" are:

- I need that last Full Backup of any client, this shall be copied. Thats it ?

Can somebody help me with the correct SQL Query syntax ?

Thanks for your help in advance!

Beste Regards

Torsten

--
Besuchen Sie dass IT dieses Jahr auf der Cebit:
http://www.dass-it.de/events/dass-it-2011-erstmalig-auf-der-cebit

--
Torsten Maus torsten.maus AT dass-it DOT de
dass IT GmbH Phone: +49.221.3565666-98
http://www.dass-IT.de Fax: +49.221.3565666-10

Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRB52500
Geschäftsführer: S. Dühr, M. Außendorf, J. Steffens, Philipp Storz

------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users