it seems it be easier to just create a backupset with a 1 day retention.


Tony Garrison
I/T Sr. Systems Programmer
USAA
210-913-9836



-----Original Message-----
From: Richard Sims [mailto:rbs AT BU DOT EDU]
Sent: Friday, January 03, 2003 6:34 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: On which volumes are my files?


>Does anyone know a fast way to get a list of all volumes on which a node
>has files of a specific subdirectory? A query of the volumeusage table
>does the job on filespace level but not on file/directory level.
>The only way I know is to search in the output of query content or the
>corresponding select query which is very slow.

The Content query is the standard method - which has to wend its way through the
whole file inventory to gather the limited information you need.
There is another, "creative" approach: Perform a client restore of that
subdirectory to a trash area, and then see what tapes were mounted.  :-)
If you have ready access to the same type of system as that client, and know the
client's password, you can perform the restoral cross-node, and not actually
have to use that client.  Restore doesn't have to go through the SQL layers that
we have to when issuing server commands, and is certainly far faster.

  Richard Sims, BU

   "Think different."   - Apple