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.
