pshearer
Active Member
Anyone else out there played with SQL 2008 Database Mirroring for E1 yet? I’ve been doing some testing and JDE app servers, as well as any ODBC based connections, seems to failover cleanly. (With traditional SQL failover clustering you typically have to restart your JDE services post failover.) In tests where I pskilled sqlservr.exe service on my Principal SQL server the app server cleanly failed over to the Mirror in slightly over 1 second. In the UBE and kernel log files you see messages stating the connection was lost and then the connection was re-established.
The one area that still requires manual intervention though is OAS (because of how Oracle is creating the JDBC connection string.)
The one area that still requires manual intervention though is OAS (because of how Oracle is creating the JDBC connection string.)