title: Transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION
body: <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>