Re: Logical log backup - Why!?

Eric R. Gavin (Eric_Gavin@maf.org) wrote: : I understand that the logical logs must be backed up consistently in order : to be freed, but why would I need to back them up otherwise? : If I did a Level 0 backup once per week and then a Level 1 every other : weekday wouldn't that be sufficient? : We're not a mission-critical, 24hour - 7 day/week organization. If we lost : a day's worth of data it wouldn't be a big deal. : Are there any reasons to do Level 0, Level 1 AND preserve our Logical Log : backups? Right now I'm thinking of setting a continuous backup and : redirecting the Logical Log Tape Device to NUL. : Would anybody counsel against this? And why? If you absolutely do not care about recovery of up-to-second-of-crash data, I'd say go for it. Be careful, though that the full and partial archives really have all the data you need to come back whole as of the date of last level-0 or date of last level-1. I've seen systems that keep other items, such as logs and temp files in non-database files that need to be kept in synch with the database. In a lot of cases, though (yours sounds like one), the effort of physically managing the logfile tapes may outweigh the need to reprocess a day's data (if you can easily reprocess a day's work) on the outside chance that a crash may happen.. : TIA, : Eric Gavin -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DEBUGGERS Survival Guide", available early 1998 from Prentice Hall/Informix Press. If you have debugging tips, tools, or ideas to share, please send me some e-mail. ---------------------------------------------------------------------------