<div>
So, there is really nothing different between simple and full, other than simple will not fully log some bulk logged operations and it truncates the log on checkpoint. &nbsp;If you've got long running transactions, then your log is likely not having an opportunity to truncate.
</div>


So, there is really nothing different between simple and full, other than simple will not fully log some bulk logged operations and it truncates the log on checkpoint.  If you've got long running transactions, then your log is likely not having an opportunity to truncate.

<div>
<div class="content wysiwyg-content">
Hi,<br />
My database is in the simple recovery mode. During bulk-operations it is growing very high and utilization of memory space is very high and we had a seperate drive for ldf files. After some time again it came to its original size. <br />
Pl, let know why it is growing when it is in simple recovery? The cause might be SQL Server may not have enough time to run a checkpoint and complete the log truncation? Correct if I’m wrong?<br />
Let me know the best practice to maintain the log file when it is in simple recovery?<br />

</div>
</div>


Hi,
My database is in the simple recovery mode. During bulk-operations it is growing very high and utilization of memory space is very high and we had a seperate drive for ldf files. After some time again it came to its original size. 
Pl, let know why it is growing when it is in simple recovery? The cause might be SQL Server may not have enough time to run a checkpoint and complete the log truncation? Correct if I’m wrong?
Let me know the best practice to maintain the log file when it is in simple recovery?


high usage ldf file of memory in simple recovery

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.