Re: Big Problem with SQL Logs

Will LaSala ( will@greennet.net )
Thu, 12 Jun 1997 10:07:08 -0400

I have 2 seperate Log Devices each is 200mb's
and they are both full. I checked off those items
but now how should I go about clearing out some
of the wasted space?
I have 632 MBR's and a 250mb Emerald Database
with 400 mb's of Log space and Everything is full.
So is there a way that I could clear out or make these
databases and logs smaller?

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
>