Navigation |

February 18, 2009

Get list of BizTalk host instance with specific status

The code below expects to execute on the machine its querying for.
Code:

‘ WMI script to get list of BizTalk host instance with specific status

‘ MSBTS_HostInstance.ServiceState valid values

‘Stopped: 1
‘Start pending: 2
‘Stop pending: 3
‘Running: [...]

Filed by Paul Gu at February 18th, 2009 under BizTalk, Programming
No comments on this post yet

February 13, 2009

Good tools in BizTalk 2004

There are two tools that I recommend here.
The first is the BizTalk 2004 Explorer Extension.
The extension is the BtsAsmExt.dll and is located in the \Program Files\Microsoft BizTalk Server 2004\Developer Tools subdirectory. This functionality is turned off by default (which is why most people don’t know about it). To enable this functionality, run regsvr32 BtsAsmExt.dll either [...]

Filed by Paul Gu at February 13th, 2009 under BizTalk, Programming
No comments on this post yet

February 10, 2009

BizTalk SQL Agent Jobs

Execution of the BizTalk Server SQL Agent jobs are crucial for managing the BizTalk Server databases and for maintaining optimal performance. The Backup BizTalk Server job is the only supported method to backup the BizTalk Server databases and requires that all of the BizTalk Server databases are configured to use the SQL Server full recovery [...]

Filed by Paul Gu at February 10th, 2009 under BizTalk, Database
2 persons have commented this post

February 9, 2009

Archiving and Purging the BizTalk Tracking Database

As BizTalk Server processes more and more data on your system, the BizTalk Tracking (BizTalkDTADb) database continues to grow in size. Unchecked growth decreases system performance and may generate errors in the Tracking Data Decode Service (TDDS). In addition to general tracking data, tracked messages can also accumulate in the MessageBox database, causing poor disk [...]

Filed by Paul Gu at February 9th, 2009 under BizTalk, Database, Programming
No comments on this post yet

February 6, 2009

WMI script to update send handler host

In BizTalk Server 2004, sometime we need to update host for a send handler, the script below will do the job.

Option Explicit

‘ wbemChangeFlagEnum Setting
const UpdateOnly = 1

UpdateSendHandler
‘ MSBTS_ReceiveHandler host association update
Sub UpdateSendHandler ()
‘Get the command line arguments entered for the script
Dim Args: Set Args = WScript.Arguments

‘error handling is done by explicity checking the err object [...]

Filed by Paul Gu at February 6th, 2009 under BizTalk
No comments on this post yet

WMI script to update receive handler host

In BizTalk Server 2004, sometime we need to update host for a receive handler, the script below will do the job.

Option Explicit

‘ wbemChangeFlagEnum Setting
const UpdateOnly = 1

UpdateReceiveHandler
‘ MSBTS_ReceiveHandler host association update
Sub UpdateReceiveHandler ()
‘Get the command line arguments entered for the script
Dim Args: Set Args = WScript.Arguments

‘error handling is done by explicity checking the err object [...]

Filed by Paul Gu at February 6th, 2009 under BizTalk
No comments on this post yet

WMI script to update orchestration host

In BizTalk Server 2004, sometime we need to update host for a batch of orchestrations, the script below will become very handy.

Option Explicit

EnlistOrchHost
Sub EnlistOrchHost()
‘Get the command line arguments entered for the script
Dim Args: Set Args = WScript.Arguments

‘error handling is done by explicity checking the err object rather than using
‘the VB ON ERROR construct, so set [...]

Filed by Paul Gu at February 6th, 2009 under BizTalk
No comments on this post yet