Thanks
Will
----
From: Dale E. Reed Jr. <daler@iea.com>
To: emerald@emerald.iea.com
Date: Wednesday, June 11, 1997 11:04 PM
Subject: Re: Big Problem with SQL Logs
>Will LaSala wrote:
>>
>> I got a BIG problem here
>> I have 2 log devices that are totally full.
>> 400 Megs of nothing but logs.
>> When I go in and tell it to trunacate the Log
>> It seems to get bigger not smaller.
>>
>> I can't figure out how to Dump the info in the log files
>> I don't need any of the log info nad I've never used the logs for
>> SQL so if there is a way to turn off loggin totally please tell
>> me.
>>
>> So right now I can't save or do anything to emerald
>
>Go into SEM, double click on the database, and check:
>
>Bulk Copy/Into
>Truncate on Checkpoint
>No Checkpoint on Recovery
>
>Enabling those three should keep your logs pretty small. I wouldn't
>know why your logs are that big. Do you have them on a seperate
>device from your database?
>
>--
>Dale E. Reed Jr. (daler@iea.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.emerald.iea.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>