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.

more ▼

asked Mar 18, 2010 at 03:02 AM in Default

avatar image

562 29 31 36

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Mar 18, 2010 at 07:05 AM

avatar image

Rob Farley
5.8k 16 22 28

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Mar 18, 2010 at 02:28 PM

avatar image

Steve Jones - Editor ♦♦
5.2k 79 94 87

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

Mar 18, 2010 at 02:45 PM venkatreddy
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 18, 2010 at 03:02 AM

Seen: 2170 times

Last Updated: Mar 18, 2010 at 03:02 AM

Copyright 2018 Redgate Software. Privacy Policy