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!?
Do you Yahoo!?
Shop for Back-to-School deals on Yahoo! Shopping.