Re: To log or not to log, that is the question.

>Would the only benefit be that you could do backups of the logs and therefore >have incremental backups since your last "big" backup? Even an "unlogged" database writes DDL to the logs. And checkpoints are logged. But, if you don't log, your backups will be valid to only the last checkpoint. Use buffered logging - it's fast and reasonably secure. -- Cheers, Billy. ----------------------------------------------------------------------------- billy.wheeler@pixie.co.za +27 11 803 2151 p.o. box 3463, rivonia, rsa, 2128 +27 83 250 2324 i'm schizophrenic: my opinions are not those of me -----------------------------------------------------------------------------