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. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com