SAP DR and MS SQL

[Former Member]

Hi All,

We're using SAP ECC 6.0 with backend database MS SQL Server 2008 R2 (SP1)(Enterprise 64 bits).

We've 2 set of DR systems, for instance: DR-01 and DR-02.

DR-01 is the real DR system and it's been configured with log shipping.

DR-02 is a new DR system which will used for testing purpose, installed with SQL server, but no log shipping.

Both DR systems are using VM machine.

Currently, we're planning not to touch the log shipping in DR-01 system.

However, for DR testing in DR-02, we wanted to redirect user logon from DR-01 server to access another SQL server on DR-02.

Will it be possible to have such situation?

How can it be done if it's possible?

Please advise.

Thank you.

- Jack

[Former Member]

What do you mean of -

>> we wanted to redirect user logon from DR-01 server to access another SQL server on DR-02.

are you going to start the database on DR-01 or not? if not then I think you can use the database server as DR-02 (you have to change the database server SAP profile parameter) and SAP instance on DR-01, it should work.

But if you are going to start the database on DR-01 and then want to use the DR-02 as database then its not possible.