How to Add a New MessageBox Database
You can use the BizTalk Server Administration Console to add a new MessageBox database to your BizTalk Server deployment. MessageBox databases are the basis for load-balancing work items across servers that do cooperative processing. To increase the number of messages that your system can process, you may need to add additional MessageBox databases.
You cannot create a new MessageBox database and have enlisted orchestrations, send ports, or send port groups at the same time. Enlisted orchestrations, send ports, or send port groups access data that BizTalk Server must copy to the new MessageBox database. While this data is being accessed, BizTalk Server cannot copy it into the new MessageBox database.
You can designate both local and remote databases as MessageBox databases. For information about BizTalk Server databases, see Databases in BizTalk Server.
SQL Server Agent must be running on all of the SQL servers to which you want to add a new MessageBox database.
Administrators who manage MessageBox databases must have the required user rights. You must have the following user rights to manage MessageBox databases and disable new message publication:
You must be logged on as a member of the BizTalk Server Administrators group.
You must be a SQL Server Administrator on the computer where the database exists.
To add a new MessageBox database
Click Start, click All Programs, click Microsoft BizTalk Server 20xx, and then click BizTalk Server Administration.
In the console tree, expand BizTalk Server Administration, expand the BizTalk group, and then click Platform Settings.
Right-click Message Boxes, click New, and then click Message Box.
In the Message Box Properties dialog box, do the following, and then click OK:
Use this To do this SQL Server Displays the name of the SQL server that hosts the MessageBox database. Database Displays the name of the MessageBox database. Master subscription message box Indicates whether the selected MessageBox database is the master. If the current MessageBox database is the master, this check box is selected and unavailable. The first MessageBox database created when you run the Configuration Wizard is the master by default. Disable new message publication Select this check box to specify that you do not want this MessageBox database to receive activation messages.