1
Vote

support of backup compression

description

Hi,
 
It would be useful to support back compression for sql server 2008 .
This would need to check what edition is running at the source and destination server, because
this feature is only supported by enterprise and developer edition.
 
BACKUP DATABASE AdventureWorks
TO DISK = 'C:\SQLData\AdventureWorks_compressed.bak'
WITH COMPRESSION, INIT, STATS = 10
 
regards

comments