none
What happen if restart BizTalk Server And SQL Server when an application is running? RRS feed

  • Question

  • Hi All,

    As title, i am planning to make schedule to restart BizTalk Server ánd SQL Server.

    I would like to know that

    What happen if i restart these 2 servers when an application is still running.

    Does it resume when the servers start again. or it will be terminated.

    Thanks

    Thursday, June 1, 2017 9:49 AM

Answers

  • Stop IIS and Receiving Hosts Instances on BizTalk
    Close Biztalk Server
    Restart SQL Server
    Start BizTalk Server

    BizTalk services needs to be configured with Automatic (Delayed start) in Services snapin

    NB! If Enterprise Single SignOn is not running Biztalk will not start

    hth  /Peter

    Thursday, June 1, 2017 12:54 PM
  • The best procedure is:

    1. Disable all Receive Locations.
    2. Stop all BizTalk Host Instances.
    3. For Updates, Stop SQL Server and stop related BizTalk Services such as SSO and IIS.  Apply all updates.
    4. Restart SQL Server and BizTalk Server.  You can do this at the same time or whenever Update finishes.
    5. Start your Applications to their normal runtime configuration.

    Thursday, June 1, 2017 1:04 PM
    Moderator
  • Follow the steps:

    1. Stop all receive locations
    2. monitor for all inflight transactions till they move to dehydrated or completed state.
    3. Stop the Orchestrations.
    4. Stop the Send Ports
    5. Clustered host instances (take offline)
    6. Apply the updates.
    7. Stop the BizTalk Servers (Shutdown)
    8. shutdown the SQL servers.

    For the startup, reverse the sequence.

    Also refer: https://msdn.microsoft.com/en-us/library/dd792679.aspx


    Rachit Sikroria (Microsoft Azure MVP)

    Saturday, June 3, 2017 1:45 PM
    Moderator

All replies

  • U can have message loss for in flight messages if persistence did not happen. 

    Other dehydrated or waiting process will rehydrate.


    Pi_xel_xar

    Blog: My Blog

    BizTalkApplicationDeploymentTool: BizTalk Application Deployment Tool/


    Thursday, June 1, 2017 10:02 AM
    Answerer
  • Stop IIS and Receiving Hosts Instances on BizTalk
    Close Biztalk Server
    Restart SQL Server
    Start BizTalk Server

    BizTalk services needs to be configured with Automatic (Delayed start) in Services snapin

    NB! If Enterprise Single SignOn is not running Biztalk will not start

    hth  /Peter

    Thursday, June 1, 2017 12:54 PM
  • The best procedure is:

    1. Disable all Receive Locations.
    2. Stop all BizTalk Host Instances.
    3. For Updates, Stop SQL Server and stop related BizTalk Services such as SSO and IIS.  Apply all updates.
    4. Restart SQL Server and BizTalk Server.  You can do this at the same time or whenever Update finishes.
    5. Start your Applications to their normal runtime configuration.

    Thursday, June 1, 2017 1:04 PM
    Moderator
  • Follow the steps:

    1. Stop all receive locations
    2. monitor for all inflight transactions till they move to dehydrated or completed state.
    3. Stop the Orchestrations.
    4. Stop the Send Ports
    5. Clustered host instances (take offline)
    6. Apply the updates.
    7. Stop the BizTalk Servers (Shutdown)
    8. shutdown the SQL servers.

    For the startup, reverse the sequence.

    Also refer: https://msdn.microsoft.com/en-us/library/dd792679.aspx


    Rachit Sikroria (Microsoft Azure MVP)

    Saturday, June 3, 2017 1:45 PM
    Moderator