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:[EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 3:26 PM To: [EMAIL PROTECTED] 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
