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:[EMAIL PROTECTED] On Behalf Of TSM_User Sent: Thursday 09 September 2004 03:59 To: [EMAIL PROTECTED] 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.
