Database Mirror connection string in sql 2008

240 pts.
Tags:
Database mirroring
SQL Server 2008
SQL Server Database Mirroring
SQL Server Mirroring
Hi All, I have three databases which i have configured mirror on sql server 2008 for all the databases. Manual Failover with one principal and mirror. (Witness planning in the future) Using Windows authentication (Since same login and pass, neither new endpoints are created and not certificate created) This is working smoothly. I have 7 .net applications which uses these three databases. All the 7 applications uses the same three databases. 1)I need how to provide the connection strings for these applications to get connected. 2)In case if failover is applied on only one databes, then how does it work? Because in some joins I have to connect two different databases and retrive the data. What will be the syntax for the connection strings in this case. What are the steps to be taken care to run the applications smoothly.? Thanks for any inputs.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You should just need to add “Failover Partner=myMirrorServerAddress;” to the connection String. If you are using cross database joins then both databases will need to be active on the same server for the joins to work, otherwise you will get an error saying that the database isn’t available.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • GIG
    Thanks for your reply. In case if i need to failover a single db, then i have to failover all the other db's on the server.
    240 pointsBadges:
    report
  • GIG
    Thanks MRDenny Also, will i have any performance gains if i use different ports for each individual db on the server, as i have three db's to configure mirror.
    240 pointsBadges:
    report
  • Denny Cherry
    No you won't. I'm not sure if you even can. I think you can only have one Mirroring Endpoint per instance.
    66,005 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following