RE: Question on setting up failover
From: Chris Skorlinski (ChrisSkor_at_Online.Microsoft.com)
Date: 08/22/04
- Next message: Chris Skorlinski: "RE: Change username"
- Previous message: Chris Skorlinski: "RE: INstalling sp3a on second node"
- In reply to: Mike Cooper: "Question on setting up failover"
- Next in thread: Mike Cooper: "RE: Question on setting up failover"
- Reply: Mike Cooper: "RE: Question on setting up failover"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 22 Aug 2004 07:42:50 GMT
There are a couple of different options:
1) Have a HTML page you can substiute for your main web page saying "down
for maintenance" when SQL Server is shut-down, for low-priority web sites,
a simple, cheap solution until your database server is back up and running.
2) Use database replication technology (Microsoft solution or 3rd party
product like Double-Take http://www.nsisoftware.com/pro/doubletake) then
modify the global.asa or web.config to the standby SQL Server as needed.
3) Use cluster technologies allow SQL Server to automatically restart on a
backup node, should one node of a cluster have a hardware failure. The web
apps connect to a virtual SQL Server name or IP. That name and IP are
automatically reassigned to the new node. No change in the connection
string is required.
Chris Skorlinski
Microsoft SQL Server Support
Please reply directly to the thread with any updates.
This posting is provided "as is" with no warranties and confers no rights.
- Next message: Chris Skorlinski: "RE: Change username"
- Previous message: Chris Skorlinski: "RE: INstalling sp3a on second node"
- In reply to: Mike Cooper: "Question on setting up failover"
- Next in thread: Mike Cooper: "RE: Question on setting up failover"
- Reply: Mike Cooper: "RE: Question on setting up failover"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
