title: Alternative to BACKUP LOG WITH TRUNCATE_ONLY
body: <p>This piece of T-SQL is deprecated in 2005:</p>
  
  <pre><code>BACKUP LOG [DB_NAME] WITH TRUNCATE_ONLY
  </code></pre>
  
  <p>I don't need to keep a backup the log for my db - but I do not want the piece of code to stop working if we port to SQL2008 or successive versions in future.</p>
  
  <p>Cheers</p>