Backup Compression Feature
Applies: SQL Server 2008 (Katmai) CTP November 2007, SQL Server 2008
Backup compression is supported only by SQL Server 2008 Enterprise Edition or
later, but any edition of SQL Server 2008 can restore a compressed backup.
The backup compression feature is off by default in SQL Server 2008. However,
you can change this behavior by overriding this server-level configuration
option, doing one of the following two procedures:
EXEC sp_configure ‘backup
compression default’, '1';
RECONFIGURE WITH OVERRIDE;
Or go to the Server Properties Dialog
On the Database Settings page of the Server Properties dialog, click on the
"Compress backup" check box.