Re: Are logs any use in a no logging database?

1. No! 2. Writes always occur to the log for certain commands (moslty all update/alters/creates). It will write to the log, yet if your log is point to /dev/null (that's like never never land) no real write occurs only disk access. Yet the eninge does count it as an write!!!! It does in otherwords access /dev/null. If I'm wrong! the expert's will pipe it in right. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Wed, 22 May 1996 Spetc@aol.com wrote: > We do not use logging on our database. > > 1. We perform level 0,1 archives, but we don't backup the logs, do we really > need to? > > 2. What are the logs used for in a no logging database? For example, if I > update every row in a table with 10 million rows with a single update > statement and I interrupted it half way through would the first 5 million > updates be rolled back? Would it use the logs for this purpose? > > Thanks in advance. >