Adding a New MessageBox Database

You use the BizTalk Administration console to add a new MessageBox database to your BizTalk deployment. MessageBox databases are the basis for work item load balancing 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.

For information about the user rights required to create new MessageBox databases, see Required User Rights for Managing MessageBox Databases.

Important  Do not create a new MessageBox database when you enlist orchestrations, send ports, or send port groups. These operations access data that BizTalk Server must copy to the new MessageBox database. BizTalk Server cannot copy data into the MessageBox database while these operations access the same data.

Before you add a new MessageBox database, you must first create a new database. You can designate both local and remote databases as MessageBox databases. For information about BizTalk Server databases, see BizTalk Server Database Creation and Configuration.

Important  SQL Server Agent must run as the database owner for all of the MessageBox databases on all of the MessageBox SQL servers before you create a new MessageBox database.

To add a new MessageBox database

  1. Click Start, point to All Programs, point to Microsoft BizTalk Server 2004, and then click BizTalk Server Administration.
  2. In the Administration console, expand the Microsoft BizTalk Server 2004 (local) node, right-click MessageBoxes, click New, and then click MessageBox.
  3. In the New MessageBox dialog box, do the following:
    Use thisTo do this
    Database Name Type the name of the MessageBox database.
    SQL Server Type the name of the SQL server where this database will be created.
    Disable New Message Publication Select this check box if you do not want this MessageBox database to start receiving activation messages at this time.
  4. Click OK.

See Also

Managing MessageBox Databases

Disabling New Message Publication

Deleting a MessageBox Database

Restoring the BizTalk MessageBox Database

To download updated BizTalk Server 2004 Help from www.microsoft.com, go to http://go.microsoft.com/fwlink/?linkid=20616.

Copyright © 2004 Microsoft Corporation.
All rights reserved.
Show: