SQl Server 2008 standard Mirror architecture, fail over without changes in applications
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
Software/Hardware used:
Sql server 2008 standard 64 bit, sql server Standard databas
ASKED:
July 19, 2011 8:10 PM
UPDATED:
March 31, 2012 8:56 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
