Re: Point in time recovery

David Williams wrote: > [...] > Possibly consider a level 0 archive at lunchtime if you can get > everyone to log off for an hour and it will take less then an hour. > A pain but if you keep do it regularly the development staff would > get used to taking their lunch at the same time each day. > [...] > > David Williams Why should everybody log off while doing backup? Isn't online backup one of Informix strong points? We surely do it (with version 5 and ontape), and it slows the system down slightly. As far as I understand, if you back up the entire instance, you can restore up to certain point in log files (which translates to certain time). If one wishes to restore only a certain database, one should back them up separately (under version 5 the only solution was to have separate instances.) Regards, Dragi "Bonzi" Raos +--------------------------------------------------------+ | 4-MATE Information Engineering Inc. | +--------------------------+-----------------------------+ | 4-MATE | Tel: +385 (1) 242-116 | | Kosa bb | +385 (1) 242-126 | | 10000 Zagreb | Fax: +385 (1) 242-121 | | Hrvatska (Croatia) | e-mail: bonzi@4mate.hr | | | URL: http://www.4mate.hr | +--------------------------+-----------------------------+