Re: Emerald Log files.

Josh Hillman ( (no email) )
Thu, 29 Jan 1998 12:31:36 -0500

From: Richard Sensale <>
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

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