I'm running ADSM Server version 3.1.2.20 / ADSM Client 3.1.0.6. I have a group
of client nodes that share a common tapepool. I lost an entire filespace on
one of the nodes & now have to restore it.
Each node backs up multiple partitions directly to the tapepool (primary pool)
every night, and the tapes are sent off-site the following day, so all the tapes
I need for the restore are off-site. I can't afford the cost or time to wait
for an ADSM restore session to iteratively prompt for the next tape volume, then
go retrieve it from our off-site storage vendor. I pay a fixed premium for each
emergency tape delivery, regardless of the number of tapes delivered, plus there
is a 2-hour minimum delay per delivery. I need the ability to identify and
recall all tapes that will be needed, before I initiate the restore.
Does anyone know an SQL Select query (or any other way) to identify all/only
those tapes needed to restore filespace X on node Y, either for all active files
only (point-in-time 'now') or for a point-in-time Z ?
-rsvp
=========================================================================
|