Skip to Content

Sub minute recovery time?

Has anybody heard about a high availability solution for SAP on SQLServer which allows recovery times under 1 minute?

I know SAP does not certify high availability solutions from partners, so I think this has to be a hardware solution from a SAP partner (HP, IBM, etc.).

As I know, every HA solution would need some kind of failover for database engine and SCS. Database failover will took always about tens of minutes.

I will appreciate any guidance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 16, 2008 at 03:52 PM

    We have SQL 2008 (Release Candidate 0) Mirroring in place (same as SQL 2005, but SQL 2005 is more stable of course, since it is a released product). Our mirroring mode is synchronous with automatic failover.

    At SAP level, we have setup database mirroring via supported methods. Just modify the database reference in your profiles, from a single database name to:

    SAPDBHOST = primarydbserver;Failover_Partner=secondarydbserver

    In event of db failure, at the DB level it takes less than 5 seconds to failover. SAP work processes will error but will be successful during reconnect. Average failover takes less than 1 minute from my experiences.

    If you are looking for sub 1 min recovery, do not, I repeat - do not use MSCS. Fastest I have ever seen any MSCS recover is around 5 minutes. MSCS is affected by IPSEC, network name replication, etc. Because the name is moved from 1 physical server to another.

    For SQL mirroring, there are no name changes, SAP simply point to another server.

    Add comment
    10|10000 characters needed characters exceeded