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:[EMAIL PROTECTED]]On Behalf Of Tony Morgan Sent: Friday, August 16, 2002 11:21 AM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: 16 August 2002 15:48 To: [EMAIL PROTECTED] 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.
