On Sat, 14 Feb 1998 12:59:33 -0800, you wrote:
>iml@interconnect.net wrote:
>>=20
>> Just wondering what cuts down the log device size or what process I
>> should do to cut the size down.
>>=20
>> 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
>enabled:
>
>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. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com