This sounds strange to me!  My DB backups seem to be kept for 1 month
and then expire, so I am dedicating 30 3590 tapes to holding DB
backups.  As mentioned this is a bit excessive.  Isn't there a
parameter somewhere to specify how long to keep them for rather than
running a regular schedule with "del volhist t=dbb tod=-###"?

The only thing I can think of is that it uses the Standard Policy
Domain, which in my case has the backup retention set to 30 days.  I
suppose I could just reduce this.

Cheers,
Simon

----------
| From: ADSM-L AT VM.MARIST DOT EDU; Cris.Robinson AT LIBERTYMUTUAL DOT COM
| From: ADSM-L AT VM.MARIST DOT EDU; Cris.Robinson AT LIBERTYMUTUAL DOT COM
| To: ADSM-L AT VM.MARIST DOT EDU
| Subject: Re: DB Backup Volumes
| Date: Wednesday, 20 May, 1998 12:02AM
|
| I have to jump in for a sec. I also use the "del volhist t=dbb tod=-###"
| command but I find that
| ADSM finds that the media is innaccessable the next time the particular
| tape comes up in the
| rotation for database backups. Any thoughts on that subject?
|
| Thanks -
| CR
|
| ________________________
| Cris Robinson
| Senior Technical Analyst
| Desktop Services Technical Support
| Liberty Mutual Insurance
| 603.431.8400.54837
| cris.robinson AT libertymutual DOT com
|
| > -----Original Message-----
| > From: Dwight Cook [SMTP:decook AT AMOCO DOT COM]
| > Sent: Tuesday, May 19, 1998 11:14 AM
| > To:   ADSM-L AT VM.MARIST DOT EDU
| > Subject:      Re: DB Backup Volumes
| >
| >      Also a "query volhist t=dbb"  (that is type=databasebackup) will
| > show
| >      you what is there.... to get rid of them and let the volumes roll
| > back
| >      into scratch status you simply do a "del volhist t=dbb tod=-###"
| > where
| >      ### is a number of days to go back in time from the current date.
| > I
| >      use "del volhist t=dbb tod=-7" so I delete db backups older than
| > one
| >      week. NOW I WOULD NEVER THINK OF trying to recover from a week
| > old
| >      dbbackup 'cause of the time involved to audit everyting but this
| > gives
| >      me the ability to say I'm covering things to my best ability.
| >      later
| >           Dwight
| >
| >
| >
| > ______________________________ Reply Separator
| > _________________________________
| > Subject: Re: DB Backup Volumes
| > Author:  HWhitehead (HWhitehead AT CAISO DOT COM) at unix,mime
| > Date:    5/18/98 6:47 PM
| >
| >
| > From the administrative command line, use q libvolume (format=detailed
| > if you want much detail).  The far right hand column will give you
| > your
| > info.
| >
| > Hilary Whitehead
| > California Power Exchange
| >
| > > -----Original Message-----
| > > From: Greg Garrison [SMTP:Greg.A.Garrison AT BANKAMERICA DOT COM]
| > > Sent: Friday, May 15, 1998 4:21 PM
| > > To:   ADSM-L AT VM.MARIST DOT EDU
| > > Subject:      DB Backup Volumes
| > >
| > > Hi all!
| > >
| > > You know... this is one of those questions I feel embarrassed to
| > ask,
| > > but I
| > > can't remember where I can go to find out which of my tapes contain
| > DB
| > > backups.  Sure could use some help.
| > >
| > > Greg Garrison
| > > Bank of America
|