SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 ASP.NET
 how can i change web configs automatclly
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

2revup
Posting Yak Master

108 Posts

Posted - 01/02/2007 :  22:33:42  Show Profile  Reply with Quote
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?

Thanks

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/03/2007 :  04:01:50  Show Profile  Reply with Quote
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.

Kristen
Go to Top of Page

2revup
Posting Yak Master

108 Posts

Posted - 01/03/2007 :  19:53:34  Show Profile  Reply with Quote
Thanks Kristen i didnt think of that way, i will see what i can find that can do this. I might just have to do a scriptto get this to work also.
mmmmm

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000