I have a senario where 2 DB servers are in sync, if one goes down then the other is availbe to take over.
so lets say When the application on the web servers could not connect to the first SQL box it will talk to the second SQL box automatically. And when the first SQL box comes back it will talk to it automatically.
this is all well and good but how can i achive this through the web.config, the only thing i can think of is make a script that will ping at freqent intervals and then once it cant communicate then do a find and replace and then once its all up and working again then do a find and replace again. Is there any applications that might do this for me or better is there a better way about going about this whole senario?
I believe the "normal" way to handle this is that the Reserve server changes IP address to replace the Primary (when the Reserve detects that the Primary is unavailable). Thus no application changes are needed.