PowerShell script to Start or Stop All BizTalk Host Instances
# Import external assembly and create a new object
[void] [System.reflection.Assembly]::LoadWithPartialName(“Microsoft.BizTalk.ExplorerOM”)
$Catalog = New-Object Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer
#BizTalk Config
$Catalog.ConnectionString = “SERVER=JEETU;DATABASE=BizTalkMgmtDb;Integrated Security=SSPI” #connectionstring for the BizTalkMgmtDb
$Hostinst = “” # Define variable for host instances
$resultToWrite=“”
$OutResultLog = ‘E:\Biztalk\BizTalkLive\BizTalkPowerShellService\StartStopHostInstnace\logStartStopHostInstance.txt’
#$ServerName=”” #Define running server name
#Function to start host instances with filter condition
function StartHostInstance()
{
$resultToWrite=‘Process has started to start host instance on date : ‘+(Get-Date).ToString()
Add-Content $OutResultLog $resultToWrite
$resultToWrite=“”
#get all in-process host instances
[ARRAY]$hostInstances = Get-WmiObject MSBTS_HostInstance -namespace “root\MicrosoftBizTalkServer” -Filter “(HostType = 1 )” # and RunningServer = ‘$ServerName’ –If you want to add server in filter co
foreach ($Hosts in $catalog.Hosts )
{
foreach($Hostinstance in $Hosts ){
try
{
$Hostinst = $Hostinstance.Name
foreach($hostinst1 in $hostInstances | WHERE {($_.HostName -eq $Hostinst) -and ($_.HostName -notlike ‘BizTalkLive’)}) {
if ($hostinst1.ServiceState -eq 1) # 1 = host instance is stoped
{
$hostinst1.Start()
#Wait for few seconds
Start-Sleep -s 2
$resultToWrite=$resultToWrite+ ‘Started host instance: ‘+$Hostinst+ ‘ at datetime :’+(Get-Date).ToString()
Add-Content $OutResultLog $resultToWrite
$resultToWrite=“”
}
}
}
catch [Exception]
{
$resultToWrite=$resultToWrite+ ‘Getting Exception: ‘+ $_.Exception.Message +‘ to Start host instance: ‘+$Hostinst+ ‘ at datetime: ‘+(Get-Date).ToString()+“`r`n”
Add-Content $OutResultLog $resultToWrite
$resultToWrite=“”
}
}
}
$resultToWrite=$resultToWrite+ ‘Process end to start host instance on datetime: ‘+(Get-Date).ToString() +“`r`n”
Add-Content $OutResultLog $resultToWrite #logged all details in log file
[void]$Catalog.Refresh()
}
#Function to stop host instances with filter condition
function StopHostInstance()
{
$resultToWrite=‘Process has started to stop host instance on date : ‘+(Get-Date).ToString()
Add-Content $OutResultLog $resultToWrite
$resultToWrite=“”
#get all in-process host instances
[ARRAY]$hostInstances = Get-WmiObject MSBTS_HostInstance -namespace “root\MicrosoftBizTalkServer” -Filter “(HostType = 1 )” # and RunningServer = ‘$ServerName’ –If you want to add server in filter co
foreach ($Hosts in $catalog.Hosts )
{
foreach($Hostinstance in $Hosts ){
try
{
$Hostinst = $Hostinstance.Name
foreach($hostinst1 in $hostInstances | WHERE {($_.HostName -eq $Hostinst) -and ($_.HostName -notlike ‘BizTalkLive’)}) {
if ($hostinst1.ServiceState -eq 4) # 4 = host instance is running
{
$hostinst1.Stop()
#Wait for few seconds
Start-Sleep -s 2
$resultToWrite=$resultToWrite+ ‘Stopped host instance: ‘+$Hostinst+ ‘ at datetime :’+(Get-Date).ToString()
Add-Content $OutResultLog $resultToWrite
$resultToWrite=“”
}
}
}
catch [Exception]
{
$resultToWrite=$resultToWrite+ ‘Getting Exception: ‘+ $_.Exception.Message +‘ to Stop host instance: ‘+$Hostinst+ ‘ at datetime: ‘+(Get-Date).ToString()+“`r`n”
Add-Content $OutResultLog $resultToWrite
$resultToWrite=“”
}
}
}
$resultToWrite=$resultToWrite+ ‘Process end to stop host instance on datetime: ‘+(Get-Date).ToString() +“`r`n”
Add-Content $OutResultLog $resultToWrite #logged all details in log file
[void]$Catalog.Refresh()
}
#call function to start host instances
StartHostInstance
#call function to start host instances
StopHostInstance