From: [log in to unmask] on 02/12/98 06:46 PM

Please respond to [log in to unmask]


To:   [log in to unmask]
cc:    (bcc: Lee Gunter/BCBSO/TBG)
Subject:  Re: FW: Opinions solicited on database repair "gotchas"




> Ditto ... I'm frequently asked why we bother with Image transaction
logging
> ... this is the reason.
>
> Lee Gunter

So, how do you insure that log files will be turned over at just before
each backup?  (I'm not familiar with the details true online operation.)

>> We do a :CHANGELOG on each logging identifier prior to :LOG ..., STOP.
Log files are backed up every night.  We don't use online backup.  All
logging cycles are restarted weekly.

Do you keep separate log files for each database?

>> In some cases ... one identifier logs four databases ... the rest are
set up as one per log ID.

Do you prohibit Operators from using store/restore directly (ie. only
usable from a command file)?  Do you keep Operators in a menu?

>> No, and no.  See my first post to this thread.  ;-)

Humans have a knack for finding some way to break anything.:-)

>> Sure ... but we can try to protect us (and our data) from ourselves!