SQL Server 2008 Backup Compression Standard Edition -

I am trying to back up the database in SQL Server 2008 and am compressing the database by using the new compression feature . However, when I run the following code, I get a strange error message:

  backup database & lt; Database & gt; I get this error message:  
 
 The backup database with compression is not supported on standard version  

/ P>

Does this mean that I have to upgrade to the full version or is there a way to enable compression in the standard version? Backup communication is not supported on SQL 2008 Express, Workgroup, or Standard Edition, only on Enterprise.

There is no way to turn your edition on without having to upgrade it in the enterprise.

Although you can not back up with compression on those versions, you can restore it from compressed backups.

More info.