Alex Rivera | Logout

SQL Server 2008 Backup Compression Standard Edition

Asked 2009-01-29T16:00:52.233
15

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:

Backup Database <Database> To Disk 'C:\Backup' With Compression

I get this error message:

Backup Database With Compression is not supported on Standard Edition

Does this mean I have to upgrade to the full version or is there a way to enable compression in standard edition?

sql-server sql-server-2008 compression backup
Edit
Report

1 Answer

15

Backup Compression is not supported on SQL 2008 Express, Workgroup, or Standard editions, only on Enterprise. There is no way to turn this on without upgrading your version to Enterprise.

Although you can't backup with compression on those versions, you can RESTORE from compressed backups.

See http://technet.microsoft.com/en-us/library/bb964719.aspx for more info.

answered 2009-01-29T16:10:09.390

Your Answer