Solved

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

Posted on 2013-12-16
5
298 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 11

Expert Comment

by:HuaMinChen
ID: 39723004
0
 
LVL 17

Assisted Solution

by:Emmanuel Adebayo
Emmanuel Adebayo earned 250 total points
ID: 39723010
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 39723015
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
ID: 39723121
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
ID: 39739718
tx
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

717 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