Re: BUFFERED LOGGING: Is it safe??

In article <42qvig$27e@cssun.mathcs.emory.edu>, Neil M Stevenson <nmsteven@eukcumb1po.unitedkingdom.ATTGIS.COM> wrote: > >Just my 2 pence worth, but have you thought about this: > >If your server has a UPS, then upon a power failure your server should >shutdown cleanly. (If it has been setup correctly) During this shutdown, >OnLine will flush all buffered logs to the disk. Your transactions are >therefore safe. > >If your server does not have a UPS, then the only option you have is >unbuffered logging. Power failures are only one cause of system crashes, sw bugs in the OS and the Database are also likely causes and for these UNbuffered Vs buffered makes a difference. > >However, if you have a disk crash you will lose the WHOLE logical log (this >is also assuming that continuous logical log backup to tape is running >otherwise you will lose a DAY or more!) regardless of whether you have >buffered or unbuffered logging :-( This is why mirroring the root, physical log, and logical log chunks is a good idea. At $0.40/MB or less, its cheap insurance. -jrg -- internet jrg@galloway.sj.ca.us John R. Galloway, Jr 795 Beaver Creek Way applelink D3413 CEO...receptionist San Jose, CA 95133 Galloway Research (408) 259-2490 v (408) 259-5058 f