BizTalk manually clears the MessageBox Database

Overview when running BizTalkServer, the data stored in the MessageBox database may need to be deleted. In these cases, a quick method is required to clear data from the MessageBox database. We can use the bts_CleanupMsgbox stored procedure to manually clear data from the MessageBox database. However, it is recommended that you only

Overview when running the BizTalk Server, the data stored in the MessageBox database may need to be deleted. In these cases, a quick method is required to clear data from the MessageBox database. We can use the bts_CleanupMsgbox stored procedure to manually clear data from the MessageBox database. However, it is recommended that you only

Overview

When running the BizTalk Server, the data stored in the MessageBox database may need to be deleted. In these cases, a quick method is required to clear data from the MessageBox database. We can use the bts_CleanupMsgbox stored procedure to manually clear data from the MessageBox database. However, it is recommended that you only perform these steps in the test and development environments. We do not recommend that you manually clear the key business data in the production environment.

How to manually clear MessageBox

Stop BizTalk Service

• Stop all BizTalk instances in the Service Management Console.
• If you are running any adapter in an independent host (such as HTTP, SOAP, or WCF), run IISRESET from a command prompt to restart IIS.
• Disable any self-defined independent adapters that are running.

Use SQL Server to create and execute bts_CleanupMsgbox stored procedures

• Click Start, all programs, Microsoft SQL Server 2008 R2, and SQL Server Management Studio ".
• In the "connect to SQL Server" dialog box, select SQL Server and the authentication method, and click "Connect ".
• In the "available database" drop-down list, select the BizTalk Messagebox database (BizTalkMsgBoxDB by default ).
• Click the new query icon on the toolbar.
• Open the msgbox_cleanup_logic. SQL file from SQL Server Management Studio. The msgbox_cleanup_logic. SQL file is on the drive of the BizTalk Server: \ Program Files \ Microsoft BizTalk Server 2010 \ Schema \ directory.
• Click the execute query icon on the toolbar to run the script to create the bts_CleanupMsgbox stored procedure. The bts_CleanupMsgbox stored procedure is then displayed as dbo. bts_CleanupMsgbox In the stored procedure list.
• Click the new query icon on the toolbar.
• Paste the command into the new query window: exec bts_CleanupMsgbox.
• Run the query and restart the BizTalk service as needed.