Re: How many db of each can be configured?

Home Page Forums BizTalk 2004 – BizTalk 2010 How many db of each can be configured? Re: How many db of each can be configured?

#24737

For clustering Biztalk databases, go here: http://msdn.microsoft.com/en-us/library/ee308825(BTS.10).aspx

For multiple MessageBox databases, go here: http://msdn.microsoft.com/en-us/library/aa561513(BTS.20).aspx

You do not need a load balanced device to share the load, most BizTalk databases only allow a single running instance, so clustering is active/passive.
The MessageBox allows multiple databases, but load distribution is managed by BizTalk.

The DTA database has a single active instance, although you can create archive databases and use the Purge and Archive SQL Job to move data from the active instance to an archive instance.