Another question about database mirroring: are clients redirected?

Another question I'm afraid.

I've just been reading some information about SQL database mirroring.  It lists the following 'features' of mirroring:

1. Full database redundancy
2. Near instantaneous failover within 3 seconds
3. Failover can be performed manually or automatically.
4. No special hardware requirements.
5. Ease of manageability as it is easy to set up and can be configured to be self monitoring for automatic failover.
6. Transparent client redirection

My question is about the 6th option.  I didn't know the clients were redirected if the database fails over to the mirror.  I thought you'd need SQL clustering for that.

If I have an application writing data to a database on Server1 and it fails over to Server2, will the application start writing the information to the (now principle) database on Server2?
LVL 10
DarylxAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

brejkCommented:
If this application uses SQL Native Client OLEDB you can use FailoverPartner keyword in your connection string to cause transparent redirection.
0
digital_thoughtsCommented:
It depends on how you are connecting to your database, but take a look at http://www.sqlservercentral.com/articles/SS2K5+-+High+Availability/3046/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SvenTech Lead Web-DevelopmentCommented:
When using ADO.NET or the SQL Native Client and using a third sql server as witness, you can have automatic redirecting on failover.

If you are using classic ADO or another connection to sql server you have to write a script for the redirecting yourself.
0
slam69Commented:
Basically if the witness and server 2 agree that server 1 has gone down then yes the writing will then commence on server 2 as the primary then when server 1 comes back online it will be synchronised by server 2 and then become the redundant back up
0
slam69Commented:
sorry should be clear when server 1 comes back and is then synchronised again with server 2, server 1 will then be the back up
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.