<div>
Important note!<br />
I'd recommend you to backup your database or at least dump your transaction log beforehand.<br />
<br />
Or you could use DUMP TRAN &lt;db&gt; WITH no_log<br />
but remember, log of transactions will be lost. <br />
<br />
Hth.
</div>


Important note!
I'd recommend you to backup your database or at least dump your transaction log beforehand.

Or you could use DUMP TRAN <db> WITH no_log
but remember, log of transactions will be lost.

Hth.

<div>
that was incredibly helpful, I have been struggling with this for a while
</div>


that was incredibly helpful, I have been struggling with this for a while

<div>
<div class="content wysiwyg-content">
Is there a way of truncating (or shortening) the .ldf that is associcated with my database within SQL Server 2000?
</div>
</div>


Is there a way of truncating (or shortening) the .ldf that is associcated with my database within SQL Server 2000?

Truncating .ldf file in SQL Server 2000

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.