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

venkatreddy gravatar image

562 29 29 32

(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

Rob Farley gravatar image

Rob Farley
5.7k 16 18 20

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, 2010 at 01:03 PM venkatreddy
(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

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 78 79 82

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: 1991 times

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