Brad
> -----Original Message-----
> From: Dale E. Reed Jr. [SMTP:daler@iea-software.com]
> Sent: Thursday, April 22, 1999 11:57 AM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] SQL Error 1105
>
> Brad Teague wrote:
> >
> > Hello, I've been having problems with my EmeraldLog filling up
> > lately. I went to the database the other day and hit "Truncate Log" and
> it
> > worked. Well, today it had filled up again and I went to the Database
> and
> > hit "Truncate Log" and it wouldn't work. My current log size was 100MB
> and I
> > had to expand it to 200 MB just to get Emerald to start working again.
> No
> > one was able to create a new user or anything because it couldn't write
> to
> > the log I guess. It had obviously halted all such activity. Does anyone
> know
> > why my log is filling up so much? and how to manage it? I've worked with
> IEA
> > on this once and set all the standard scheduled tasks and what not, but
> this
> > is one that they said "they" didn't feel comfortable setting a scheduled
> > task to delete. From what I've read, i'm assuming it isn't suppposed to
> fill
> > up like it is now. It seems to be doing it very quickly and that is
> nothing
> > but bad.
> > The biggest problem is that I can't seem to delete (truncate)
> the
> > log now. Any ideas on this anyone?
>
> Do you have:
>
> > > No Checkpoint on Recovery
> > > Truncate Log on Checkpoint
>
> Enabled for your Emerald Database? That usually will keep the log size
> down. Also, do a CheckDB on your Emerlad database, then do a recalc and
> truncate. The stats on your DB Might be wrong, which is causing the log
> to be shown wrong.
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com