Skip to Content
0

MSSQL database high availability for MES SAP application

Jun 14, 2017 at 05:42 AM

92

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Luis Darui
Jun 14, 2017 at 02:53 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded