Using BizTalk Terminator

BTSTerminator is a handy tool for managing your BizTalk database environment. Unfortunately it's design is a little confusing.

1. Enter the database server name
2. Enter the name of the management database

BTSTerminator requires that you verify that all the BT databases are backed up, that all host instances on the application server have been stopped, and that all BT SQL Agent jobs are stopped before you can proceed. The thing to note here is that BTSTerminator does not verify these things for you so you need to verify that these are done and then check the check boxes before proceeding. Once everything is checked you can click the Connect button.

The next screen is where things get confusing.

The bottom row of buttons are not actions, they are categories. So if you want to delete orphaned instances you first click the Delete button which changes the options in the top drop down menu.

Basically, all BTSTerminator is, is a collection of various SQL Scripts that are accessed and executed through the (clunky) UI.

1. Select the category of action you want to do (View, Delete, Manage, etc)
2. Select the appropriate task from the drop down menu

3. Click the Parameters tab and verify the parameters (usually just a confirmation of the server and database names)
4. Click Execute

BTSTerminator will then execute the chosen script on the server/database and display the results on the Results tab.