As always, it depends . . . Our TSM DB is on raided enterprise disk (IBM DS8100 behind a SAN Volume control) as is our TSM LOGs. We run our logs in roll forward mode. The odds of losing both the DB and LOG except in a DR situation is small. If we have to restore the DB, we can roll forward using the logs. If we lose the logs, we can do a DB backups and have a clean restore point with the new logs.
So DR is our main concern. Therefore, we backup DB right after our Backup STG to make offsite copies of the data. Our order is: Backup Backup Primary to copy Backup DB Move copy and DB offsite Migrate primary disk to primary tape Expiration Reclamation Start all over again We do backup stg before migration so 1) we can do the bulk of our copy pool creation disk to tape rather than tape to tape, 2) get data offsite as quickly as possible. David Ehresman University of Louisville >>> Mark Scott <[EMAIL PROTECTED]> 7/18/2007 9:29 AM >>> I believe the best practise is Backup Migration Backup primary to copy Backup db Expiration Reclamation Start all over again :) Cheers -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: Wednesday, 18 July 2007 9:14 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Server DB Backups We actually backup ours after nightly backups complete and before migration. Is there a specific recommended order or is it up to each individual site and it's environment? Helder Garcia wrote: > You should backup db after migration and before expiration. > > On 7/17/07, Gregory Lynch <[EMAIL PROTECTED]> wrote: > >> >> Hello all, >> >> How many times a day should I be backing up the TSM DB and should it be >> after migration? >> >> >> Thanks >> >> Greg >> >> >> *************************************************************** >> Gregory Lynch >> Lead Programmer Analyst >> IT Infrastructure/Systems Administration >> Stony Brook University Medical Center >> HSC Level 3, Room 121 ZIP 8037 >> Phone: 631-444-9783 >> [EMAIL PROTECTED] >> >> This e- mail message, including any attachments, >> is for the sole use of the intended recipient(s) and may >> contain confidential and privileged information. >> Any unauthorized review, use, disclosure or distribution is prohibited. >> If you are not the intended recipient, please contact the sender >> by e-mail and destroy all copies of the original. >> > > > > -- > Helder Garcia ************************************************************************ Bunnings Legal Disclaimer: 1) This email is confidential and may contain legally privileged information. If you are not the intended recipient, you must not disclose or use the information contained in it. If you have received this email in error, please notify us immediately by return email and delete the document. 2) All emails sent to and sent from Bunnings Group Limited. are scanned for content. Any material deemed to contain inappropriate subject matter will be reported to the email administrator of all parties concerned. ************************************************************************