Re: Big Problem with SQL Logs

Dale E. Reed Jr. ( (no email) )
Wed, 11 Jun 1997 20:03:20 -0700

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  |