Can anyone point out how i will be able to make a compressed dump I can't find in BOL or the GUI how to enable this.
In several blog's and Microsoft articles it is mentioned as a new feature.
SQL Server Katmai Disaster Recovery and Availability
Can anyone point out how i will be able to make a compressed dump I can't find in BOL or the GUI how to enable this.
In several blog's and Microsoft articles it is mentioned as a new feature.
Backup Compression will be included in the next public CTP, due out later this month.
When you install that CTP, the BOL that comes with it will have full documentation on backup compression.
That said, there will be syntax added to the BACKUP DATABASE command:
BACKUP DATABASE ... TO ... WITH [NO]COMPRESION
Also, there is an instance-wide option, settable via sp_configure which sets the default for backups which do not explicitly specify the compression setting. Out of the box, the default setting is OFF.
Hi,
will this option (COMPRESSION) be available in all SQL 2008 editions (Standard, Enterprise, etc.) or only in the Enterprise edition
Thanks,
Hi,
SQL Server 2008 Enterprise Edition and later supports compressing backups.
I think MS dropped the ball on this one, Why make this an enterprise feature Smaller shops with smaller hard drives need backup compression just as badly as Enterprise users do...
P.S. A little note to MSFT folks: Oracle Express (the free edition) has backup compression built-in FOR FREE!
this may help
Madhu