ADSM-L

Re: HELP / How can I generate a list of the tapes needed to restore an entire filespace ?

1999-10-18 23:26:37
Subject: Re: HELP / How can I generate a list of the tapes needed to restore an entire filespace ?
From: "Laura G. Buckley" <buckley AT STORSOL DOT COM>
Date: Mon, 18 Oct 1999 21:26:37 -0600
Here's a select command that will show you all volumes that a client's data
is on for a given storage pool.  The only problem with it is that it shows
both active and inactive files, but at least you've got a list of tapes for
that client (many of which you won't need unless you are doing a PIT
restore).

select distinct node_name, volume_name from volumeusage where
node_name='NODENAME' and stgpool_name='STGPOOLNAME'



Laura G. Buckley
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719)531-5133, FAX (719)260-5991
buckley AT storsol DOT com
www.storsol.com