Hi:

I've got a client who is running about 5 database on SQL Server 2000.

The databases are about 25 - 100 megs each.
The log files in some cases are huge.
In one case the log file is 68 GIGS.

Rebooting, backing up, shrinking the log file doesn't help.

Why are they so huge? Is there a setting that may be causing this?
More importantly, how can I shrink them?
Can I just delete them in SQL Server (Enterprise Manager?)
I see where it lets me but I don't know the consequences.

__________________
http://www.softlinksys.com
Professional Software Developer since 1994.

Hi
Please check the following articles:
http://support.microsoft.com/kb/317375/EN-US/
http://support.microsoft.com/kb/272318/EN-US/
http://support.microsoft.com/kb/110139/EN-US/


Om Prakash

Thanks for the articles.

I did a BACKUP LOG <database> WITH TRUNCATE_ONLY

Then I went into Enterprise Manager and used the 'Shrink Database' but then shrunk only the 'Files' > log file.

Whew!! That deleted about 100 GIGS of unwanted log data.

THANKS a bunch!!

I would recommend to create a scheduled job in SQL Server for truncating your log files.

BACKUP LOG db_name WITH TRUNCATE_ONLY
WAITFOR DELAY '00:00:10'
DBCC SHRINKFILE(dbname_log,targetsize)

Yea, that's a good idea.

I'll do that.
Thanks:)