support of backup compression

Mar 24, 2009 at 9:23 PM

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.

TO DISK = 'C:\SQLData\AdventureWorks_compressed.bak'

Mar 24, 2009 at 9:26 PM
I just found an article of using SERVERPROPERTY in T-SQL for getting the sql server edition.

Perhaps this could be a fix property in the "Servers" dialog, so you have to check this only once .

Mar 25, 2009 at 12:20 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.