BizTalk Server Tutorials and Solutions Skip to main content

Posts

Showing posts from November, 2017

PowerShell script to restart all host instances in multiple server for SFTP adapter at Send handler side

In my previous post for restart host instance for sftp receive side and same with PowerShell Script that restart all host instances for SFTP protocol at send side. The below following script is very simple and you can also change SFTP adapter to another adapter like WCF-SQL, FTP, File etc. I am writing PS Script for SFTP adapter because if you are working more than 100 SFTP server then after some times it goes to slow to pick file from sftp server after restart sftp host instance the caches is clear and its start working fine. # 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=.;DATABASE=BizTalkMgmtDb;Integrated Security=SSPI"   #connectionstring for the BizTalkMgmtDb $Hostinst = "" # Define variable for h

PowerShell script to restart all host instances in multiple servers for SFTP adapter at Receive handler side

Again with PowerShell Script that restart all host instances for SFTP protocol at receive side in multiple server environment. The below following script is very simple and you can also change SFTP adapter to another adapter like WCF-SQL, FTP, File etc. I am writing PS Script for SFTP adapter because if you are working more than 100 SFTP server then after some times it goes to slow to pick file from sftp server after restart sftp host instance, the caches is clear and its start working fine. # 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=.;DATABASE=BizTalkMgmtDb;Integrated Security=SSPI"   #connectionstring for the BizTalkMgmtDb $Hostinst = "" # Define variable for host instances $resultToWrite = &quo