title: SQL Server 2008 Backup Compression Standard Edition
body: <p>I'm trying to backup a database in SQL Server 2008 and have the database compressed using the new compression feature. However, when I run the following code, I get a weird error message:</p>
  
  <pre><code>Backup Database &lt;Database&gt; To Disk 'C:\Backup' With Compression
  </code></pre>
  
  <p>I get this error message:</p>
  
  <blockquote>
    <p>Backup Database With Compression is not supported on Standard Edition</p>
  </blockquote>
  
  <p>Does this mean I have to upgrade to the full version or is there a way to enable compression in standard edition?</p>