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.
exec
[dbo].[sp_SetBackupCompression] @bCompression = 0 /*0 - Do
not
use Compression, 1 - Use Compression */
On the General page, in the Command box, edit the command, and then click OK. See MSDN How to Configure the Backup BizTalk Server Job.
Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki. Read suggested related topics:
Sandro Pereira edited Revision 7. Comment: Fixing SQL code format
Lex Hegt edited Revision 4. Comment: Added link to the Aspects of BizTalk Server Backups article
Steef-Jan Wiggers edited Revision 3. Comment: Fixed Typo
Steef-Jan Wiggers edited Revision 2. Comment: Added text and resource links
Steef-Jan Wiggers edited Original. Comment: Added resource link