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?