Re: Big Problem with SQL Logs

Will LaSala ( )
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?


From: Dale E. Reed Jr. <>
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. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |
> ----------------------------------------------------------
> Emerald Mailing List