Perfect, that is exactly what I needed.

Thanks

P Baines <paul.baines AT ECB DOT INT> wrote:
If the object_ID is nnnnnnn then issue the command:

SHOW BFO 0 nnnnnnn

Which will show you the volume name(s)


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
TSM_User
Sent: Thursday 09 September 2004 03:59
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Select to find what tape a single file is on


We have an 60 GB Exchange server that we keep 90 versions of. They want
me to pull out the tape that has the backup from 7/20 on it and a
database backup and send it to another location for restore. Now I know
I could run an export with fromdate but that will run for 7 days produce
20 tapes with 3 TB's of data.

I see that the backups table has the file_name, backup_date and
something called object_ID. I see the contents table has_file name and
file_hexname.

I know that when I use the TSM GUI to select a single file for restore
TSM determines what tape needs to be mounted in seconds. So, where is
the table that helps link the file requested for restore to the tape
volume it is on.

Has anyone had to do this select before. I know that many have
discussed at great length the long query you would need to run to
determine what tapes you would need to restore an entire server. I'm
not asking for all that. I have one specific file name. OK actually 6
but I know each name and I don't mind running a select on each one.




---------------------------------
Do you Yahoo!?
Shop for Back-to-School deals on Yahoo! Shopping.



Any e-mail message from the European Central Bank (ECB) is sent in good faith 
but shall neither be binding nor construed as constituting a commitment by the 
ECB except where provided for in a written agreement.
This e-mail is intended only for the use of the recipient(s) named above. Any 
unauthorised disclosure, use or dissemination, either in whole or in part, is 
prohibited.
If you have received this e-mail in error, please notify the sender immediately 
via e-mail and delete this e-mail from your system.


---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.