BizTalk Server 2010: Database BizTalkMsgBoxDb

  • Article

This article will contain information about the BizTalkMsgBoxDb database.

*NOTE: This article is a stub. Information will be added as soon as possible.
*

Tables

ActiveRefCountLog
AddRef
ApplicationProps
Applications
Name of all hosts you have in BizTalk
BitwiseANDPredicates
Contains subscription related data (the AND predicates)
BizTalkDBVersion
Contains information regarding the version of BizTalk you are running and that this is the MessageBox database
ConvoySetInstances
Contains information regarding ConvoySets
ConvoySets
Contains information regarding ConvoySets
DynamicStateInfo_HostName
EdiControlNumbers
EdiIncomingEdifactICN
EdiIncomingX12ICN
EdiInt_InboundMessageIdentity
EdiInt_Mic
EqualsPredicates
Contains subscription related data
EqualsPredicates2ndPass
Contains subscription related data
ExistsPredicates
Contains subscription related data
FirstPassPredicates
Contains subscription related data
Fragments
Messages are divided in Parts and Fragments. This table holds the Fragments.
GreaterThanOrEqualsPredicates
Contains subscription related data
GreaterThanPredicates
Contains subscription related data
Instances
Contains information and refrences to all instances in BizTalk
InstancesOperatedOn
Contains information regarding all refrenced instances being operated on
InstancesPendingOperations
Contains information regarding all instances pending to be operated on
InstancesSuspended
Contains information regarding all instances that are suspended.
InstanceStateMessageReferences_HostName
JobData
LessThanOrEqualsPredicates
Contains subscription related data
LessThanPredicates
Contains subscription related data
LocalizedErrorStrings
MarkLog
Marklog table used as reference for the BizTalk backup job.
MessageParts
MessagePredicates
MessageProps
MessageRefCountLog1
MessageRefCountLog2
MessageRefCountLogTotals
MessageZeroSum
Modules
Contains the BizTalk applications from this BizTalk Group
HostName_DequeueBatches
HostName_MessageRefCountLog
HostNameQ
HostNameQ_Scheduled
Messages scheduled to work on by this host
HostNameQ_Suspended
Suspended messages for this host
NotEqualsPredicates
Contains subscription related data
OperationsProgress
PartRefCountLog1
PartRefCountLog2
PartRefCountLogTotals
Parts
Messages are divided in Parts and Fragments. This table holds the Parts.
PartZeroSum
PredicateGroup
Contains subscription related data
PredicateGroupNames
Contains subscription related data
PredicateGroupZeroSum1
Contains subscription related data
PredicateGroupZeroSum2
Contains subscription related data
ProcessHeartbeats
Heartbeats for all host
Release
ServiceClasses
Contains information for all service classes with ID's
Services
References to the service class with all services in BizTalk
Spool
The table which holds the messages which are in-process
StaticStateInfo
Subscription
Contains subscription related data
Tracking_Fragments1
Tracking_Fragments2
Tracking_Parts1
Tracking_Parts2
Tracking_Spool1
Tracking_Spool2
TrackingData_0_0
Data going from the Messagebox to the BAM database.
TrackingData_0_1
Data going from the Messagebox to the BAM database.
TrackingData_0_2
Data going from the Messagebox to the BAM database.
TrackingData_0_3
Data going from the Messagebox to the BAM database.
TrackingData_1_0
Data going from the Messagebox to the tracking database.
TrackingData_1_1
Data going from the Messagebox to the tracking database.
TrackingData_1_2
Data going from the Messagebox to the tracking database.
TrackingData_1_3
Data going from the Messagebox to the tracking database.
TrackingDataPartitions
TrackingMessageReferences
TrackingSpoolInfo
TruncateRefCountLog
TrustedUsers
Information regarding trusted user per application.
UniqueSubscription

See Also

Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki.