Batch files to stop and start the BizTalk and SQL Services

On my local BizTalk development machine I sometimes want to stop the BizTalk services and all other related services including SQL Server. So I created the following batch file that takes care of it:

Net stop "edi subsystem"
Net stop RuleEngineUpdateService
Net stop BTSSvc$BizTalkServerApplication
Net stop NS$BAMAlerts
Net stop ENTSSO
Net stop MSBizTalkRFID
Net stop W3SVC
Net stop SQLSERVERAGENT
Net stop MSSQLSERVER
Net stop ReportServer
Net stop MSSQLServerOLAPService
Net stop SQLBrowser
Net stop msftesql
Net stop MsDtsServer
Net stop SQLWriter
@ECHO Services stopped.
pause

Consequently this is the batch file to start it:

Net start MSSQLSERVER
Net start SQLSERVERAGENT
Net start ReportServer
Net start MSSQLServerOLAPService
Net start SQLBrowser
Net start msftesql
Net start MsDtsServer
Net start SQLWriter
Net start W3SVC
Net start MSBizTalkRFID
Net start ENTSSO
Net start NS$BAMAlerts
Net start BTSSvc$BizTalkServerApplication
Net start RuleEngineUpdateService
Net start "edi subsystem"

@ECHO Services started.
pause

This is for a machine running BizTalk Server 2006 R2 and SQL Server. A few things to note:

• You might not have some of the services listed on your machine. For example, the MSBizTalkRFID service won’t be there if you haven’t installed BizTalk RFID on the server.
• You need to add any extra BizTalk host instances to the list. I only have the default host there (BTSSvc$BizTalkServerApplication).
• It is only stopping SQL Server with a default instance. If you have a named instance you might need to change it.

Let me know if I’ve missed anything!