When you run backup compression, custom databases that are a part of BizTalk backup jobs will also be compressed. Database backups will happen without compression if backup compression is enabled on databases that belong to non-enterprise editions of SQL
Server. If you are a Sysadmin, a warning message will be displayed in the SQL Server’s Event Viewer.
Note: Creating compressed backups is supported only in SQL Server 2008 Enterprise and later versions.
The feature can be used through BizTalk Server Backup Job. You can configure compression by Job Properties of the Backup BizTalk Server. In the Job step list, click
Set Compression Option, and then click Edit.
[dbo].[sp_SetBackupCompression] @bCompression = 0 /*0 - Do
use Compression, 1 - Use Compression */
On the General page, in the Command box, edit the command, and then click
How to Configure the Backup BizTalk Server Job.
Read suggested related topics: