469,600 Members | 2,543 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,600 developers. It's quick & easy.

Log File (LDF) ???? (HELP)

Is there any way to clear out the LDF file or reduce in size?

thank you in advance fro any help,
Michael Kintner
Sep 6 '07 #1
2 4052
Hi
DBCC SHRINKFILE. For more details please see BOL
http://www.karaszi.com/sqlserver/info_dont_shrink.asp

"Michael Kintner" <no****@nospam.comwrote in message
news:13*************@corp.supernews.com...
Is there any way to clear out the LDF file or reduce in size?

thank you in advance fro any help,
Michael Kintner

Sep 6 '07 #2
On Thu, 6 Sep 2007 08:29:16 -0400, "Michael Kintner"
<no****@nospam.comwrote:
>Is there any way to clear out the LDF file or reduce in size?

thank you in advance fro any help,
Michael Kintner
First, what recovery model (Simple, Full, Bulk-Logged) is the database
using? If Simple, it will clear out by itself. For the others it
will only be cleared with the log is backed up. If no log backups are
running then it simply grows, and grows, and grows....

As for reducing the size, DBCC SHRINKFILE will do the job. However
shrinking the log file should be a VERY rare event. Shrinking the
file, only to have it grow again, is bad for performance. Allocating
more space is a significant delay for the transaction that causes it,
and physical file fragmentation is a common side effect. To over
simplify things a bit, set the log size large enough and backup the
log regularly to keep it from getting full.

Roy Harvey
Beacon Falls, CT
Sep 6 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by WKC | last post: by
7 posts views Thread by Bing Du | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.