support of backup compression

Mar 24, 2009 at 9:23 PM
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 COMPRESSIONINITSTATS 10


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

http://msdn.microsoft.com/de-de/library/ms174396.aspx

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


regards
Coordinator
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.