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

5 pts.
Tags:
MSSQL
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
Asked: Last updated:
Related Questions
1

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.
  • The Most-Watched IT Questions: August 2, 2011 - ITKE Community Blog
    [...] 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.

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

Following

Share this item with your network: