Skip to Content
avatar image
Former Member

MSSQL database high availability for MES SAP application

Hi all,

We are planning to implement HA/DR for our MES SAP application. Our ODS and WIP databases are based on MSSQL server 2012.

I need to understand how application would connect to failover database instance.

DO i need to run CTC wizard everytime after failover?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 14, 2017 at 02:53 PM

    If you're planing AlwaysOn for example, for JAVA systems (requires JDBC 4.0 or higher), in the connection string have a parameter named "MultiSubnetFailover=YES" that the application server will connect again to SQL Server after a failover, without having to restart the application server.

    I suggest going through the entire blog series to understand the AlwaysOn concept:

    https://blogs.msdn.microsoft.com/saponsqlserver/2015/10/23/sql-server-alwayson-summary/

    PS: it would be a good idea to check with SAP Product Support for SAP MII and SAP ME whether they will support it. For SAP NetWeaver-based applications, check SAP Note 1772688.

    Add comment
    10|10000 characters needed characters exceeded