I don't have the manual pulled up, but I believe that there is a way
to do a preview restore from the client that will prompt for tapes
that are required to do the restore.  I would tackle it that way.

Gary
Itrus Technologies

On Oct 7, 2009, at 1:18 PM, Brian G. Kunst wrote:

For security reasons, we're trying to identify what tapes a file is
residing on.  I've found the object_id of the file we're looking
for, 1524734887, and started a search of the CONTENTS table using
the following sql command:

SELECT * FROM CONTENTS WHERE NODE_NAME='UCSFSCL1_2' AND
OBJECT_ID=1524734887 > /home/bkunst/qcontents.out

This search has been running for over 24 hours now.  Is there a
quicker/better way to search for the volume_id for this file?

Thanks,

--
Brian Kunst
Storage Administrator
UW Technology