Transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION
<p>I tried to shrink the log file but it only did small amount of free space.</p>

<p>The log space of tempdb is full due to the data file.
How can I free the space?</p>

<p>Edit:</p>

<p>I have checked following:
1. Bad queries are running - NO Queries are running</p>

<ol start="2">
<li><p>DBCC OPENTRAN - No Result</p></li>
<li><p>The tempdb is in SIMPLE recovery mode.</p></li>
<li><p>I have a separate drive for Transaction log of 1TB i.e. 40% free now.</p></li>
</ol>

<p>Observation:
When I <code>Right click on tempdb&gt;task&gt;shrink&gt;database</code> shows 99% free space available. Can I shrink the database file here?</p>