When attempting to backup a Microsoft SQL 2008 (R2) Datacenter edition with SQL compression the message "The SQL Compression option is disabled; it is not supported by this version of SQL Server" is logged in the Job Log

Problem

When attempting to backup a Microsoft SQL Server 2008  / 2008 R2 Datancenter edition of Microsoft SQL Server and SQL Compression is enabled in the backup job SQL Compression is not used and the below message is logged in the Job Log

Error Message

Microsoft SQL Server Agent: The SQL Compression option is disabled; it is not supported by this version of SQL Server

If debugging is enabled for Backup Exec, the following message is logged.
SQL2_Connect worked.
SQL Agent: Version String { 10.50.1617.0 }
SQL edition returned: Data Center Edition (64-bit)
SQL2 Agent: Unable to set SQL flavor correctly. <Data Center Edition (64-bit)>

 

Solution

A hotfix is now available for this issue in the current version(s) of the product(s) mentioned in this article. Refer to the Hotfix link under Related Documents at the end of this article to obtain the hotfix needed to resolve the issue.


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)