|
I have a production database CTI_APPS and mirroring database CTI_APPS_LIVE,in failover situation my front end applications redirecting from CTI_APPS to CTI_APPS_LIVE.Can i maintain the same sessions in the mirrored database as it is in production database?is it possible to copy the sessions from the tempdb in production database to tempdb mirrored database? If it is so any advantage? This is an interview question for me..any help will be appriciated.
(comments are locked)
|
|
Sorry - not really. If you want anything in any other databases to be persisted, you'll have to consider putting them in the mirrored database instead. If you try to mirror extra databases, you'll have trouble failing over, because only the failed database will be switched. Thats really great,in failover switching what about the uncommitted transactions in production database ie if just after the check point my database crashed.
Mar 18 '10 at 01:03 PM
venkatreddy
(comments are locked)
|
|
When the primary fails, all clients are disconnected. There's no magic here, the client drivers will try to reconnect, and if the primary is down, they'll go to the mirror. However it's a new session, a new connection. The software makes it seemless, but it's the same as if the server rebooted. Sessions don't move. thanks Steve,also could you please look into my above comment posted to Rob? thanks in advance..
Mar 18 '10 at 02:45 PM
venkatreddy
(comments are locked)
|
