Hello Gerald,

    Here is a script I use for disaster recovery testing so I do not have to
bring each and every tape. It will give you what you are looking for.

      Take care,
          Al

Alan Davenport
Senior Storage Administrator
Selective Insurance Co. of America
alan.davenport AT selective DOT com
(973) 948-1306

/*******************************************/
/* USAGE: Run BRSLIST nodename stgpoolname */
/*******************************************/
Issue message I 'List of tapes to recover node $1 from STGPOOL $2.'
SELECT VOLUME_NAME,STATUS FROM VOLUMES WHERE VOLUME_NAME IN (SELECT
VOLUME_NAME FROM VOLUMEUSAGE WHERE NODE_NAME=upper('$1') AND
STGPOOL_NAME=Upper('$2') ORDER BY status,volume_name


-----Original Message-----
From: Gerald Wichmann [mailto:gwichman AT ZANTAZ DOT COM]
Sent: Monday, December 01, 2003 5:04 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Tape Volumes Needed for a Restore


If I load the TSM GUI and select a few directories to restore, is there some
way to determine which tapes will be required to satisfy that restore? A
sort of preview=yes option for restores? Or how would you determine which
tapes you need given a point in time restore of an entire server?

Thanks,
Gerald



This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm)
service.  For more information, visit us at www.zantaz.com.
IMPORTANT: This electronic mail message is intended only for the use of the
individual or entity to which it is addressed and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law.  If the reader of this message is not the intended recipient, or the
employee or agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  If you have received
this communication in error, please notify the sender immediately by
telephone or directly reply to the original message(s) sent.  Thank you.