Re: Database backup retentions question

At one of our sites we do this as part of our daily TSM server backup
procedure. These are some lines from a server script that does all the
storage pool backups and starting migration. Using this, if the DB Backup
doesn't work, I'm not deleting any of my previous backups. Scheduleing it as
a command will after a time remove all but the last DB backup copy if you're
not watching closely enough.

If you're using a product like Autovault to manage you vaulting procedure,
Autovault handles maintaining the specified number of DB backups and DB
Snapshot backups itself. You don't need to worry about doing it yourself. If
the DBBackup fails for a day...Autovault just won't delete any old copies.

ba db type=full devclass=3590 scratch=yes wait=yes
/*------------------------------------------------------------------*/
/* If the backup worked, then delete volhistory...                  */
/*------------------------------------------------------------------*/
if(rc_ok) -
del volh t=dbb tod=today-8

Bill Boyer
DSS, Inc.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Tony Morgan
Sent: Friday, August 16, 2002 11:21 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Database backup retentions question


Mark,

The backups are normally deleted by a scheduled task.  eg.

Administrative command schedules : DELETEDBBACKUP

        Schedule Name DELETEDBBACKUP
        Description Delete old database backups
        Command delete volhist type=dbb todate=today-3
        Priority 5
        Start date 2000-12-14
        Start time 15:00:00
        Duration 1
        Duration units HOURS
        Period 1
        Period units DAYS
        Day of Week ANY
        Expiration -
        Active? YES
        Last Update Date/Time 2001-05-29 09:24:28.000000

Type "help delete volhist" for further details.

Rgds
Tony

-----Original Message-----
From: Mark Bertrand [mailto:Mark.Bertrand AT USUNWIRED DOT COM]
Sent: 16 August 2002 15:48
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Database backup retentions question


We are backing up our database with the following command setup in an admin
script.
backup db devclass=ltoclass type=full
Is there a setting that tells how many copies of the database to keep?

My goal is to free or reclaim some tape volumes.

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

This e-mail and any files transmitted with it, are confidential and
intended solely for the use of the addressee. The content of this
e-mail may have been changed without the consent of the originator.
The information supplied must be viewed in this context. If you have
received this e-mail in error please notify our Helpdesk by
telephone on +44 (0) 20-7444-8444. Any use, dissemination,
forwarding, printing, or copying of this e-mail or its attachments is
strictly prohibited.