Re: Emerald Log files.

Rich Sensale ( (no email) )
Thu, 29 Jan 1998 13:50:55 -0500

It's not keeping the log like that, it is keeping a text log file on our
mail server when it was told not to log sql calls. It's not keeping it as a
log device in sql.

-----Original Message-----
From: Josh Hillman <admin-maillist@talstar.com>
To: emerald@emerald.iea.com <emerald@emerald.iea.com>
Date: Thursday, January 29, 1998 12:34 PM
Subject: Re: Emerald Log files.

>From: Richard Sensale <richards@glasscity.net>
>Emerald seems to be generating a rather large log file of all sql activity.
> This caused our mail server to crash this morning at 4AM. We have told
>emerald not to generate this file but it continues to do so, any
>recommended fixes for this problem. When we discovered it it was over
>400MB
>
>
>Go into SQL Enterprise Manager
>Go to the listing of databases and double-click on Emerald
>What are the following?:
> Data size
> Data space available
> Log size
> Log space available
>
>Click on the Options tab. Do you have "Truncate Log on Checkpoint"
>checked? That'll keep the log from getting out of hand.
>
>If you do a lot of transactions in a short period of time, you may need to
>manually "truncate log" (button under the "Databases" tab).
>
>Josh Hillman
>hillman@talstar.com
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>