Symptoms
Assume that you install Microsoft BizTalk Server and enable the "Backup BizTalk Server" SQL Server Agent job. Additionally, you use the script available in Post-configuration steps to optimize your environment. In this situation, you will notice that MarkLog rows are not cleaned as expected. This may cause database performance issues.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Resolution
This problem is fixed in the documentation and in the following cumulative update for BizTalk Server:
-
Cumulative Update 6 for BizTalk Server 2016
Note Get the new script from the documentation linkand update it in your BizTalk environment.
References
For information about the service packs and cumulative update list for BizTalk Server, see the following article in the Microsoft Knowledge Base:
2555976 Service Pack and cumulative update list for BizTalk Server
For more information about BizTalk Server hotfixes, see the following article in the Microsoft Knowledge Base:
2003907 Information about BizTalk hotfixes and Cumulative Update support
