<div>
Is your DB bulk logged, and if so, does it need to be?
</div>


Is your DB bulk logged, and if so, does it need to be?

<div>
How do I set to minimal logging and reduce the size of the DBlog.ldf file?
</div>


How do I set to minimal logging and reduce the size of the DBlog.ldf file?

ee_shrink2.png

ee_shrink1.png

ee_shrink3.png

<div>
<div class="content wysiwyg-content">
Greetings, the *.ldf file has suddenly grown large. Should I force a commit or rollback? Not sure how to determine next step. The volume hosing the DB is nearing 0 bytes.<br />
<br />
Thanks,<br />
johnD
</div>
</div>


Greetings, the *.ldf file has suddenly grown large. Should I force a commit or rollback? Not sure how to determine next step. The volume hosing the DB is nearing 0 bytes.

Thanks,
johnD

MS SQL DBLog file huge

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.