Raminder,

Take your list of volumes from the volumeusage table and
look up the volumes in the volumes table to see the last write date.
This should help you narrow the range of volumes, maybe even pinpoint
the exact volume, both for the onsite and copypools.

You can also select the backups for the specific date from the backups table
and then do selects from the contents of the tapes you found in step1.
Sorry, I don't have the time to include the SQL.

Hope this helps,

Bill

At 09:24 AM 8/23/2002, you wrote:
>Hello,
>   We backup our SAP/Oracle system using TDP for R/3. The OS is windows NT.
>I am trying to find out the volumes which contain the backups from last
>Friday(08/16/2002) for our production server. I have tried querying
>volumeusage table but it does not take the date condition. I would also like
>to know the copypool tapes that contain that backup and are offsite.  Does
>anyone know how to go around this.
>  Any and all help is very much appreciated.
>
>Thanks
>Raminder Braich
>SAP/Oracle DBA

----------
Bill Colwell
C. S. Draper Lab
Cambridge Ma.