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
