title: SQL Log and ACTIVE TRANSACTIONS
body: <p>I have a Web Server with SQL 2008 running a simulated SQL 2005 db, and I have a local SQL 2005 db for testing environment.</p>
  
  <p>This causes me to use scripts for backup/restoring data for testing as 2008 server backups do not restore to a 2005 server.</p>
  
  <p>When I run this SQL Query to reduce the size of a Table on my production Web SQL Server (2008)</p>
  
  <pre><code> DELETE FROM TickersDay
   WHERE (DATEDIFF(day, TickersDay.[date], GETDATE()) &gt;= 8)
   GO
  </code></pre>
  
  <p>I get this message:</p>
  
  <pre><code> Msg 9002, Level 17, State 4, Line 3
   The transaction log for database 'VTNET' is full. To find out why space in the log
   cannot be reused, see the log_reuse_wait_desc column in sys.databases
  </code></pre>
  
  <p>It comes up when I publish scripts also at times.</p>
  
  <p>When I run this SQL Command I get the following Result:</p>
  
  <pre><code> SELECT [name], recovery_model_desc, log_reuse_wait_desc
   FROM sys.databases
  </code></pre>
  
  <p>RESULT:</p>
  
  <pre><code> [name]      recovery_model_desc       log_reuse_wait_desc
  
   VTNET  SIMPLE                     ACTIVE_TRANSACTION
  </code></pre>
  
  <p>Here are my questions and issues:</p>
  
  <ol>
  <li>I get it.. I have a transaction statement that needs a Rollback Command</li>
  </ol>
  
  <p>&lt;  if @@Trancount > 0 Rollback >  .. but I have 100 stored procedures so before I do that....</p>
  
  <ol>
  <li><p>IN THE MEANTIME... how can I eradicate this issue??  I have tried SHRINKING and I have tried backuping up the Db...</p></li>
  <li><p>As you can see, it is in SIMPLE mode... I do not have any idea how to backup a LOG ONLY file... (have not found how to do that)... </p></li>
  </ol>