<div>
Read<br />
<a href="http://stackoverflow.com/questions/826789/what-is-the-ldf-file-in-sql-server" rel="ugc">What is the LDF file in SQL Server?</a>
</div>


Read
What is the LDF file in SQL Server? [http://stackoverflow.com/questions/826789/what-is-the-ldf-file-in-sql-server]

<div>
Have a read of the article I wrote on this topic: <a href="http://rdsrc.us/2nuhoK" rel="ugc">http://rdsrc.us/2nuhoK</a><br />
<br />
(Link might look a little funny since I am posting from my mobile device but it should like to an article here on EE)<br />
<br />
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.
</div>


Have a read of the article I wrote on this topic: http://rdsrc.us/2nuhoK [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.

<div>
<div class="content wysiwyg-content">
I have an database mounted to E:\ drive. i.e i have mapped the .mdf and .ldf to e: drive.<br />
But since the records are more, .ldf file size is growing.<br />
My e: drive is of 78 GB but now major portion is covered by .ldf<br />
<br />
Can we empty that so that the application works faster.<br />
The screen shot is attached. the database name is<b> ind13</b><br />
<br />
<br />
<br />
What are all the possible solutions.<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/12_w51/693010/filesize.png" target="_blank" class="file-inline" title="Screen shiot (53 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>filesize.png</a>
</div>
</div>


filesize.png

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.

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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.