Web Wiz Support and Community Forums : LDF File https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 12:00:38 +0000 Sat, 17 Nov 2007 20:27:37 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24846 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[LDF File : Thank you for your helpful replies,...]]> https://forums.webwiz.net/ldf-file_topic24846_post129434.html#129434 Author: Melkor
Subject: 24846
Posted: 17 November 2007 at 8:27pm

Thank you for your helpful replies, Jono.

I ended up changing the recovery mode to simple from full (I make weekly back-ups by routine so having it on full was really unnecessary anyway) and then I reduced the file size from there.]]> Sat, 17 Nov 2007 20:27:37 +0000 https://forums.webwiz.net/ldf-file_topic24846_post129434.html#129434 <![CDATA[LDF File : This article may be of help: h...]]> https://forums.webwiz.net/ldf-file_topic24846_post129420.html#129420 Author: Jono
Subject: 24846
Posted: 17 November 2007 at 10:19am

This article may be of help: http://forums.databasejournal.com/archive/index.php/t-21974.html
Have a look at the SQL books on-line before performing the commands, so you know what affect they will have. As always, take a backup BEFORE performing any of the actions - just in case!
 
And this may also help: http://www.thescripts.com/forum/thread144768.html


Edited by Jono - 17 November 2007 at 10:27am]]> Sat, 17 Nov 2007 10:19:38 +0000 https://forums.webwiz.net/ldf-file_topic24846_post129420.html#129420 <![CDATA[LDF File : The LDF file contains the tranaction...]]> https://forums.webwiz.net/ldf-file_topic24846_post129419.html#129419 Author: Jono
Subject: 24846
Posted: 17 November 2007 at 10:16am

The LDF file contains the tranaction logs. It is used if your recover the database from a backup.
 
The transactions should get comitted when you backup your SQL database (usually via a maintenance plan). The "recovery model" of the database also affects if you have a transaction log (a simple recovery model should create a very small LDF file).
 
Try right clicking the database in Enterprise manager and performing a backup, this may reduce the log file. If that doesn't work, post back and we can look at some other options.
]]> Sat, 17 Nov 2007 10:16:19 +0000 https://forums.webwiz.net/ldf-file_topic24846_post129419.html#129419 <![CDATA[LDF File : The .LDF log file associated with...]]> https://forums.webwiz.net/ldf-file_topic24846_post129415.html#129415 Author: Melkor
Subject: 24846
Posted: 17 November 2007 at 6:11am

The .LDF log file associated with the SQL database for this forum platform...

What is it? Why is it so much larger than the .MDF file? Can I delete it safely?

Mine is currently sat at a whopping 31gb on my server and it hurts.
]]> Sat, 17 Nov 2007 06:11:16 +0000 https://forums.webwiz.net/ldf-file_topic24846_post129415.html#129415