Thanks Wanda, that worked. Thanks everyone else too. I'm kick myself now for not just doing a test restore.
-- Brian Kunst Storage Administrator UW Technology > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf > Of Wanda Prather > Sent: Wednesday, October 07, 2009 11:26 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] What is the best why to identify what tape > volumes a backup object is residing on. > > Instructions here: > > http://www-01.ibm.com/support/docview.wss?uid=swg21114873 > > > On Wed, Oct 7, 2009 at 2:18 PM, Brian G. Kunst > <bku...@u.washington.edu>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 > >
