[Emerald] Emerald SQL log

Brad Teague ( Teague@NetworksPlus.com )
Fri, 26 Mar 1999 15:17:18 -0600

Hello, I was trying to read about and do some database maintenance
today and noticed while looking at the Emerald database that my Log Size is
100 MB, and my Log Space Available is 44.73. We have only been running
Emerald for a little over a month. I just wanted to know if I need to
truncate this log or something or does Emerald keep it at about a certain
If I need to be doing it..what exactly should I be doing and how
often. If I can set a scheduled task to do it, that would be great.
I also agree with the idea thrown into the pot yesterday about an
"Idiot's guide to database maintenance for Emerald".
I know I've seen some great entries about maintenance that if
someone at IEA (or anyone I guess) could sit down and mull through it and
with knowledgeable expertise put it together in some sort of coherent,
ordered .doc.. that would be GREAT!

Thanks in advance for any suggestions,

Brad Teague
Network Administrator
Networks Plus

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html