question

venkatreddy avatar image
venkatreddy asked

Failover in mirroring..sessions in the tempdb

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.

tempdbdatabase-mirroringsubjective
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rob Farley avatar image
Rob Farley answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Steve Jones - Editor avatar image
Steve Jones - Editor answered

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.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

thanks Steve,also could you please look into my above comment posted to Rob? thanks in advance..
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.