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.

Important

SQL Server Agent must be running on all of the SQL servers to which you want to add a new MessageBox database.

Prerequisites

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

1. Click Start, click All Programs, click Microsoft BizTalk Server 20xx, and then click BizTalk Server Administration.

2. In the console tree, expand BizTalk Server Administration, expand the BizTalk group, and then click Platform Settings.

3. Right-click Message Boxes, click New, and then click Message Box.

4. 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.

See Also

Managing MessageBox Databases
How to Disable New Message Publication
How to Delete a MessageBox Database
Backing Up and Restoring BizTalk Server Databases
The MessageBox Database