Re: SQL-BT and ADSM

This depends on whether you are using BACKUP or ARCHIVE objects in your pool
setup (OBSI V2.3).

Even though the backup job is cancelled, some of the backup may still be
good for restoring from, i.e. logical backups.
The backup process at the time of cancellation should be cleared up.
Check the SQL-BT catalogue for what it thinks is in the ADSM server, then do
a select from the BACKUP or ARCHIVE table using the same date_time values
that are in the catalogue, this should show you what ADSM thinks there is.
There is a supplied utility for expiring the old backups, I think it is
called dtoexpire (manuals not to hand right now).

Also, please supply you setup/versions for clarification.

Gary Bromley
Aspect Computing Pty
Tel: +61 (0)3 9230 2222 (Main)
Tel: +61 (0)3 9230 2242 (Direct)
Fax: +61 (0)3 9818 1320 
Email: gary.bromley AT aspect.com DOT au <mailto:gary.bromley AT aspect.com DOT 
au> 


        -----Original Message-----
        From:   Lauer Edouard [SMTP:Edouard.Lauer AT BIL-DEXIA DOT COM]
        Sent:   Sunday, June 13, 1999 12:34 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        SQL-BT and ADSM

        Hello,

        we're using SQL-BACKTRACK for doing sybase db backups via the ADSM
api
        to the ADSM server. My question is following: Because it's
SQL-Backtrack
        which
        administers it's own retention period what will happen if the backup
is
        cancelled?
        Will the objects be leaving on the ADSM server for undefinitely. Has
anyone
        had
        any experience with it?

        Thanks a lot for your help,
        _________________ Lauer Edouard ____________________
        ______ Prod. informatique ____ Systèmes Ouverts ________
        __ * +352 4590 3889 __ * Edouard.Lauer AT bil-dexia DOT com __


        =============================================================
        An electronic message is not binding on its sender.
        Any message referring to a binding engagement must be confirmed in
writing and duly signed.

        =============================================================