We started with TSM back in the ADSM 2.1 days, when the D/R module was extra-cost and a bit pricey. We came up with an in-house script to copy the volume history and the device config file to a floppy daily - and we strapped the floppy to the database backup with a heavy-duty rubber band.
We still do this, although we no longer write anything to the floppy - it's just a 'tag' for the support-team member that hauls the tapes between our computer room and our off-site storage facility. We run three floppy colors - Red, Orange, and Yellow - with seven in each set, labeled 'Sunday' through 'Saturday'. We send tapes off-site daily, with the day's database backup tape. But we only bring the database backups back on Fridays, just to simplify the process. This week, for example, is the 'Orange' week. So we've been sending over database backups with Orange floppies attached. Last week was the 'Red' week. Tomorrow, the Orange 'Friday' tape goes off-site - and all the 'Red' tapes come back to be checked back into the library. All of the database backup tapes are kept together off-site in a dedicated file drawer, separate from TSM-managed data tapes. It's simple, effective, and doesn't require looking at bits of paper at disaster recovery time. Tom Kauffman NIBCO, Inc. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Christian Svensson Sent: Thursday, February 26, 2009 1:51 PM To: ADSM-L@VM.MARIST.EDU Subject: How do you keep track of DB Backup Hi, I got a generic question for you all. How do you keep in track of your Database Backup Tape Volumes? I know you can see in Volhist the label of the volume, but how do you keep in track to get it back from the vault? Do you have a script or do you call it back one day in advance? Please, I'm really interested of your feedback and how you deal with it? Best Regards Christian Svensson Cell: +46-70-325 1577 E-mail: christian.svens...@cristie.se Skype: cristie.christian.svensson CONFIDENTIALITY NOTICE: This email and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance upon this message. If you have received this in error, please notify us immediately by return email and promptly delete this message and its attachments from your computer system. We do not waive attorney-client or work product privilege by the transmission of this message.