Without knowing the exact details of your offsite backups, your plan looks
like it will work.

The only other thing I think you need to be concerned with is the size of
the DB and LOG (make sure you re-create them the same size or larger).

In addition to coping the the three file you are, I run the following
command:

d:\adsm\saclient\dsmadmc -id=admin -password=admin macro offsite.mac >
a:\srvcfg.txt

OFFSITE.MAC

q option
q status
q db f=d
q dbvol f=d
q log f=d
q logvol f=d
q stgpool f=d
q volhist type=dbb
q vol f=d

That command gets all the server configuration information.

Chris

----------
> From: Tahir Mahmood <tmahmood AT VANSEL.ALCATEL DOT COM>
> From: Tahir Mahmood <tmahmood AT VANSEL.ALCATEL DOT COM>
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: REQUEST FOR IMMEDIATE ADVICE
> Date: Friday, January 30, 1998 11:47 AM
>
> Hi friends,
>
>
> This is a REAL TIME problem. I have to restore an extremely importnat
file.
> The details of how ADSM is setup in my shop is as follows:
>
> - ADSM V2R1..Server on OS/2 Platform.
> - ADSM clients....OS/2 WARP 3 Servers
> - Versions maintained 03
> - Backup policy calls for a set of tape volumes removed every week
> alongwith a copy of the full databse backup and a floppy containing
> dsmserv.opt, devcnfg.out and volhist.out.
> - Auto-reclamation turned off
>
> The required file is not in any of the current three versions reported by
> the current ADSM database. It is probably in the last set removed.
>
> The procedure which I have in mind goes as follows :-
>
> 1.      Migrate all data from disk stgpool to the tape pool.
> 2.      Make another full database backup reflecting most current backup
status.
> 3.      Copy the three files on a  floppy.
> 4.      Restore the database from the full db backup tape of the last
set.
> 5.      Query the dbase for the required file.
> 6.      Checkin the required tape volume as called for by the restore.
> 7.      Hopefully recover the file.
> 8.      Checkout the tape vol or vols.
> 9.      Restore databse back to its most recent status .
> 10.     Hopefully this should bring me back to the way things were.
>
> Please point out any deficiencies in my logic, if any, and offer your
> expert comments on the matter.
>
> Please I need help now !
>
> Thanks for everything,
>
> Tahir M
> ALCATEL
> Canada.
>
>
>
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> "Odd things, animals. All dogs look up to you. All cats look down on you.
> Only a pig looks at you as an equal."
>
> Winston Churchill
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=