I got you, Richard. This is exactly what is required from my point of view. We 
need to do a diaster recovery rehearsal, which I need to get the Required tapes 
to another location and restore whatever from there.

In this case, I guess only option is to bring all the offsite tapes over and 
put them ALL into the library.

Another suggestion I got is to do a selective backup before DR, that way to 
minimize the total time of restoration taken by having most recent data on 
limited number of tapes. But what about the Database with no downtime possible?

Thanks,
Brian

-----Original Message-----
From: Richard Sims [mailto:rbs AT BU DOT EDU]
Sent: Wednesday, December 03, 2003 3:26 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TSM restore media list


>        How to find out the offsite media list required for specific 
> restoration?
>See, if I know the file or directory path and dates to restore, is there anyway
>to find out which tape should be used?

Brian - Whether onsite or offsite, the product provides no means for determining
        what volumes will be needed for a restoral of specific subsets of the
backed up environment.  There is no command of feasible SQL method for 
determining
this in the general case.  Only in the simplest cases can there be any certainty
(e.g., filespace collocation, and only one tape thus far written for the
filespace).  This drawback derives from the file-oriented nature of the product,
where the philosophy is you should not need to be concerned with where files are
on what tape volumes.  It's an excellent philosophy, but inconvenient when you
are required to take some subset of your tapes to another environment to perform
restorals there.

  Richard Sims         http://people.bu.edu/rbs