Re: log device
Sun, 15 Feb 1998 03:19:54 -0600

So the Emerald Log isn't actually needed by anything in Emerald? In
other words, truncating the log never effects people's login history
info or new accounts or anything like that?

On Sat, 14 Feb 1998 12:59:33 -0800, you wrote:

> wrote:
>> Just wondering what cuts down the log device size or what process I
>> should do to cut the size down.
>> My Emerald DB data in a 400MB device and log in a 300MB separate log
>> device. My Log device is just about full and it hasn't even been
>> running a month. I need to cut that data down somehow, however, I
>> don't want to lose any pertinent information.
>Go into Enterprise manager, connect to your server, and expand down
>to your Emerald Database. Double click on it (or select edit) and
>go to the middle tab (options). You should have the following=20
>Select Into/Bulk Copy
>No Checkpoint on recovery
>Truncate Log on checkpoint
>with the later two selected, SQL Server should get the log trimmed.
>You can also use the truncate log on the first tab to manually
>truncate your log.
>Dale E. Reed Jr. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |
> ----------------------------------------------------------
> Emerald Mailing List