What about issuing the backup command with a preview=yes and then when it
completes query the actlog to see which volumes it would have asked for?

Mark


> -----Original Message-----
> From: Dusedau, Stefan [SMTP:Stefan.Dusedau AT VIACOM DOT COM]
> Sent: Tuesday, February 02, 1999 8:38 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: How to predict which tapes will be mounted during
> restore
>
> You could write an SQL to go against the "contents" table which includes
> columns for volume name, node name, file space name and file name.
>
> Thank You,
>
> Stefan Dusedau
> infoWorks
> A Viacom technology service
> (212)258-6739
> stefan.dusedau AT viacom DOT com <mailto:stefan.dusedau AT viacom DOT com>
>
>
>         -----Original Message-----
>         From:   Guntis Liepins [mailto:GLiepin1 AT EXCHANGE.TELEKOM DOT LV]
>         Sent:   Monday, February 01, 1999 11:42 AM
>         To:     ADSM-L AT VM.MARIST DOT EDU
>         Subject:        How to predict which tapes will be mounted during
> restore
>
>         Hi ADSM gurus!
>
>         Is it posible to predict which tapes will be mounted during
> restore
>         operation ?
>         ( I need to make a list of tapes,to bring the tapes from the
> secure
> offsite
>         archive,and
>         load them into 3494 library)
>         Currently ,the only way is to set library mountwait to 1 sec,run
> the
> ADSM
>         restore script
>         file by file and watch in the actlog for the tape mount requests.
> It is a
>         _very_ slow way and this
>         has a serios impact to the library (3494) operation and can cause
> some
>         backup to fail
>         during this operation. Btw,it seems that if file is split between
> two tapes
>         error log will show
>         me only the first tape.
>         This way is ok if I need to restore a few files. But if I have a
> several
>         thousands of files ,archived
>         for several years,few thousands of tapes stored partially in the
> library and
>         partially offsite
>         this is a nightmare. ADSM must keep the information where the
> files
> are
>         stored
>         somewhere in his internal database,isn't it ? I simply *could*
> *not*
>         *believe* that there are no
>         smarter and easier way like to predict which tapes is necessary
> for
> restore.
>         Please answer me - is it possible or not ?
>
>         P.S. If the q content could display not only a filename ,but also
> an
> arhive
>         description,it could be
>         a solution. Unfortunately it can't do this.
>
>
>         ------------------------------------------------------
>         Guntis Liepins
>
>         Systems administrator ,LATTELEKOM SIA
>         tel. (+371) 7224199 mob. (+371) 9240376
>         -------------------------------------------------------