[Microsoft][ODBC SQL Server Driver][SQL Server]'compression' is not a recognized BACKUP option.

Last Updated: Aug 28, 2014 09:59AM CEST
Symptom:

Backups of SQL Server databases fail.
The backup log shows the message:

[Microsoft][ODBC SQL Server Driver][SQL Server]'compression' is not a recognized BACKUP option.

Root cause:

With DataCenter version 5.2 the SQL Server Backup Option "with compression" is added by default.
Not all SQL Server versions, especially SQL Express, support this option.
 
Solution:

Log in to the SQL Server system and navigate to installdir\Hiback\MS-SQL.
Open file named himsdb.ini using an editor.
It the file does not exist, create it. Write following line into it:
 
compress=off
 
and save the file.
 
Repeat the backup.
http://assets2.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete