REM Server Clean Script
REM ===================
REM This script is ran to move the build server back to a clean state
echo Stop Cruise Control
net stop CCService
echo Stop IIS
iisreset /stop
echo Stop BizTalk Services
net stop BTSSvc$<Name of BizTalk Host>
<Repeat for other BizTalk services>
echo Stop SSO
net stop ENTSSO
echo Stop SQL Job Agent
net stop SQLSERVERAGENT
echo Clean Message Box
sqlcmd -E -d BizTalkMsgBoxDB -Q “Exec bts_CleanupMsgbox”
sqlcmd -E -d BizTalkMsgBoxDB -Q “Exec bts_PurgeSubscriptions”
echo Clean Tracking Database
sqlcmd -E -d BizTalkDTADb -Q “Exec dtasp_CleanHMData”
echo Reset TDDS Stream Status
sqlcmd -E -d BizTalkDTADb -Q “Update TDDS_StreamStatus Set lastSeqNum = 0”
echo Force Full Backup
sqlcmd -E -d BizTalkMgmtDB -Q “Exec sp_ForceFullBackup”
echo Clean Backup Directory
del E:\BtsBackups\*.* /q
echo Start SSO
net start ENTSSO
echo Start SQL Job Agent
net start SQLSERVERAGENT
echo Start BizTalk Services
net start BTSSvc$<Name of BizTalk Host>
<Repeat for other BizTalk services>
echo Start IIS
iisreset /start
echo Start Cruise Control
net start CCService