From what I have read, later versions of MDAC recognize if a database is mirrored and it caches both the primary and the mirror name.ÃÂ Then if a connection fails to the primary, MDAC transparentlyÃÂ redirects to the mirror (which in theory has taken on the primary role).ÃÂ Could someone explain how applications which rely on a DSN with a specific SQL server name defined can be redirected transparently to another SQLÃÂ server that is hosting the now "promoted" (formerly a mirror) primaryÃÂ database?ÃÂ The documentation I have read is high level and just implies it will magically work but I am looking for a deeper explanation of how transparent client redirection works from the application db connectivity perspective.
ÃÂ
Thanks,
Steve
View Complete Post