Question on setting up failover
From: Mike Cooper (mikec_at_salonbuilder.com)
Date: 08/21/04
- Next message: Chris Skorlinski: "RE: INstalling sp3a on second node"
- Previous message: Cédric: "Failover fails after applying MS03-031 patch"
- Next in thread: Chris Skorlinski: "RE: Question on setting up failover"
- Reply: Chris Skorlinski: "RE: Question on setting up failover"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 21 Aug 2004 10:39:33 -0700
I have multilple web servers running classic asp and
asp.net applications that all connect to a single MS
SQL2000 database server with multiple databases via SQL db
connection strings defined their global.asa or web.config
files.
If I need to restart the SQL server or take it offline for
maintenance all the web applications fail because they do
not have access to their data.
I am familiar with SQL replication but do not know if
there is a way to automatically have the web applications
switch from one SQL Server to another if the primary
server is offline.
Any insight or help would be greatly appreciated.
Mike
- Next message: Chris Skorlinski: "RE: INstalling sp3a on second node"
- Previous message: Cédric: "Failover fails after applying MS03-031 patch"
- Next in thread: Chris Skorlinski: "RE: Question on setting up failover"
- Reply: Chris Skorlinski: "RE: Question on setting up failover"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
