SQl Server 2008 standard Mirror architecture, fail over without changes in applications

5 pts.
Tags:
MSSQL Administration/mirror fail over
I am trying to implement the mirror architecture for SQL Server 2008 standard database. We have different processes that connected to database and I don’t have control over those environments.  I got impression that in such cases it’s better to create DNS on server site that could be used by all processes but I could not find instructions on implementation.  Could you give me some recommendation or link where I could get a details description how it should be implemented? 

Software/Hardware used:
Sql server 2008 standard 64 bit, sql server Standard databas

Answer Wiki

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

Failover for database mirroring is done through changing the connection string. There are hack ways to work around this, but the correct way to do it is to change the connection string.

Discuss This Question: 1  Reply

 
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
  • DDB007
    [...] 8. Mrdenny has a clear explanation for someone with a SQL Server 2008 standard mirror architecture who wants to perform a failover without changes in appl... [...]
    0 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