From: Mike N. 

On Mon, 30 May 2005 23:40:14 -0700, Ellen K.  wrote:

> It did occur to me that since we have static routing (I think), just
>assigning a new IP address might not be enough.  Is an "ARP
table" where
>the routing instructions live?  Would new instructions get added
>automatically?

  The "ARP table" is the IP address - to - Ethernet Hardware address
translation table that contains all ethernet hardware addresses on your LAN
segment.  It is created automatically by each host on TCP/IP as you
communicate with anything else.

   One way to eliminate the user complexity of IP switchover is to put a
'traffic director' device in front of the 2 servers.   The device would
detect a timeout / lack of response from the primary and automatically
switch to backup.   Normally these are used for web servers for redundancy
to one or more web servers from a single IP.  They may require a special
configuration or manual failover to work for SQL server in your
application.   But upon further thought - if you are using manual failover,
the same thing would be accomplished by a simple router in front of the 2 servers.

--- BBBS/NT v4.01 Flag-5