CODEWITHSUNDEEP
sql-serversql-server-2008compressionbackup
GateKiller
GateKiller

Reputation: 75869

SQL Server 2008 Backup Compression Standard Edition

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?

Upvotes: 15

Views: 25613

Answers (6)

Ubercoder
Ubercoder

Reputation: 741

To confirm, from SQL Server 2012 onwards, all editions (except Express and Web) support backup compression: https://technet.microsoft.com/en-us/library/cc645993(v=sql.110).aspx

Upvotes: -1

peterpaul
peterpaul

Reputation: 9

BACKUP DATABASE WITH COMPRESSION is not supported on Express Edition (64-bit).

Upvotes: -1

J Schafer Wilson
J Schafer Wilson

Reputation: 311

I realize this is an old post, but just to throw this out there since it showed as one of the first few entries on a Google search - with SQL Server 2008 R2, Standard Edition also gets backup compression. More information here: http://technet.microsoft.com/en-us/library/bb964719.aspx

Upvotes: 18

Henry C
Henry C

Reputation: 4801

Might be helpful as well - to determine which edition of SQL Server you're running on, run the following SQL Query:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

See http://support.microsoft.com/kb/321185

Upvotes: 3

SQLMenace
SQLMenace

Reputation: 134941

You need Enterprise Edition for that

Upvotes: 1

Scott Ivey
Scott Ivey

Reputation: 41558

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.

Upvotes: 15

Related Questions