Select to find what tape a single file is on
2004-09-09 00:15:11
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.
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Select to find what tape a single file is on,
TSM_User <=
|
|
|