These are two selects from previous entries in this forum, the first one is
more specific, the second more simple.
I have not used them, see if they help.
Regards
Maria
select filespace_name,volume_name from volumeusage where node_name='____' -
and copy_type='backup' and stgpool_name='<YourBkupStgpoolName>' group by
volume_name
select node_name,volume_name,stgpool_name from volumeusage where
node_name='$1'
----- Original Message -----
From: Nancy Reeves <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 02, 2000 9:10 PM
Subject: Tapes needed for a restore
> Is there a way to query what tapes will be needed for a given restore
> request?
>
> For instance, a user deletes a certain directory and wants to restore it.
> Since most of the files are static and have aged, they have been migrated
> to tape. I would like to make sure all the needed tapes are in the library
> before starting the restore. Is this possible?
>
> Nancy Reeves
> Technical Support, Wichita State University
> [EMAIL PROTECTED]
