Solved

What is the use of .ldf file. What to do when the size is growing.

Posted on 2013-12-16
5
291 Views
Last Modified: 2013-12-25
I have an database mounted to E:\ drive. i.e i have mapped the .mdf and .ldf to e: drive.
But since the records are more, .ldf file size is growing.
My e: drive is of 78 GB but now major portion is covered by .ldf

Can we empty that so that the application works faster.
The screen shot is attached. the database name is ind13



What are all the possible solutions.
filesize.png
0
Comment
Question by:searchsanjaysharma
5 Comments
 
LVL 10

Expert Comment

by:HuaMinChen
Comment Utility
0
 
LVL 16

Assisted Solution

by:Emmanuel Adebayo
Emmanuel Adebayo earned 250 total points
Comment Utility
0
 
LVL 22

Expert Comment

by:Steve Wales
Comment Utility
Have a read of the article I wrote on this topic: http://rdsrc.us/2nuhoK

(Link might look a little funny since I am posting from my mobile device but it should like to an article here on EE)

The LDF is your transaction log file and of you are running in full recovery mode there are certain steps you need to take in order to maintain the size of your log file.
0
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 250 total points
Comment Utility
sjwales' blog definitely covers how to do it.  As my little bit of demagoguery, I feel morally obligated to underscore an extremely important point of sjwales' post.  

in full recovery mode there are certain steps you need to take in order to maintain the size of your log file

Shrinking your log file (which you're more than likely going to have to do here, due to the size it has grown to) should always be a last resort and ***NEVER*** an automated job.  I could post tons of links about why, but Brent Ozar has already done that for us: http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/.

If your transaction log is as large as it is (which means they weren't being backed up), your business requirements are probably not so strict as they require point in time backup capabilities and you should be fine moving your database to simple recovery mode and take a daily full backup with some differentials sprinkled in along the way.
0
 

Author Closing Comment

by:searchsanjaysharma
Comment Utility
tx
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now