From: Ellen K. 

Well, but isn't clustering really for load balancing?  My SQL Servers
barely break a sweat during the day.  (Besides which SQL Server 2000
requires Enterprise Edition for clustering, but can do replication with
Standard... at a cost differential of about 4 to 1.)

On Mon, 30 May 2005 00:08:56 -0700, "Rich"  wrote in message
:

>   You should though there is clustering software for this purpose that would
probably be more appropriate.
>
>Rich
>
>  "Ellen K."  wrote in message
news:jmpk91ps7mqev59btj3aan8o3hh9is5boc{at}4ax.com...
>  Do you think I could use this for hot failover?   I.e. have a standby
>  SQL Server box with the boot partition cloned and full transactional
>  replication of the database and if the production box fails just change
>  the IP address of the clone?
>
>  On Sun, 29 May 2005 00:54:56 -0700, "Rich"  wrote in message
>  :
>
>  >   Yes and Windows 2000 too.  What probably has gotten better are
applications that register to be notified of network configuration changes
and respond so that they don't need to be restarted.  NotifyAddrChange and
NotifyRouteChange, two such APIs, were introduced in Windows 2000.
>  >
>  >   I'm curious why George had to reboot unless he was running a third party
network service that did not include support for address changes.
>  >
>  >Rich
>  >
>  >  "Ellen K."  wrote in message
news:bpmi915js372v2p66g453g1ogsrlmvlieg{at}4ax.com...
>  >  Does that also apply to Server 2003?  Because that would solve one
>  >  important issue I have at work.
>  >
>  >  On Sat, 28 May 2005 12:56:59 -0400, Mike N. 
>  >  wrote in message :
>  >
>  >  >On Fri, 27 May 2005 16:47:16 -0400, "Geo."
 wrote:
>  >  >
>  >  >>Ok so how about listing some of the features you think
makes XP worth
>  >  >>upgrading to?
>  >  >
>  >  >  To me, just being able to change the IP address without rebooting
makes
>  >  >it worthwhile.  Sometimes 2000 would be able to do this,
but most of the
>  >  >time I had to reboot.

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