DR site of SAP System (MSSQL2012, Vmware SRM)

[kazuaki_anzai]

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

[luisdarui]

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.

[patelyogesh]

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