Skip to Content
avatar image
Kazuaki Anzai

DR site of SAP System (MSSQL2012, Vmware SRM)

Feb 01, 2018 at 04:35 AM | 100 Views

Hello.

We have to install SAP system (SQLServer 2012) on Vmware, and we have to prepare DR site.

Does anyone know whether SQLServer works or not after switch over at following systems?
(Because of different IP Address, I wonder whether it works .)

Server1(FQDN:C, IPAddress:A): ERP 6.0 / SQLServer 2012 on Vmware
Server2(FQDN:C, IPAddress:B): DR site of Server1 (Vmware SRM)

Regards.
Kazuaki Anzai

Microsoft SQL Server
Virtualization
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Yogesh Patel
    Feb 08, 2018 at 01:27 AM

    Hello Kazuaki Anzai,

    On your DR site you have to use same host name for your SQL instance.

    It can be active - passive kind of setup.

    Please let me know if you have more questions, I can explain you all in detail.

    Regards,

    Yogesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Luis Darui
    Feb 12, 2018 at 07:54 PM

    This question is very trick as it is specific to your scenario, and I don't quite understand it.

    There are several techniques to build HA/DR (High-Availability/Disaster Recovery) systems.

    For SQL Server specifically, as of SQL Server 2012 you should use AlwaysOn Availability Groups. Here you can read more about it:

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

    For the ERP/NetWeaver system on Microsoft you only have the option of high-availability with the Failover Cluster (MSCS), as building a DR option it not supported/documented (means you probably have to build your own DR mechanism).

    You cannot have systems running with the same hostname.

    Add comment
    10|10000 characters needed characters exceeded