From: Ellen K. 

Oh yeah, I even printed it out for my boss as soon as I read about it...
but somehow I got the feeling that the failover included with that version
is not exactly the same failover in 2000 Enterprise.

On Tue, 31 May 2005 08:08:11 -0700, "Rich"  wrote in message
:

>   Nope.  There should be some SQL Server 2005 info on www.microsoft.com.
>
>Rich
>
>  "Ellen K."  wrote in message
news:ea2o91dfssf3j9lidmatlbtiesa3io724b{at}4ax.com...
>  I read that SS2005 will have failover in the version between the new
>  Enterprise and the new Standard, do you know anything about that?
>
>  On Mon, 30 May 2005 15:51:41 -0700, "Rich"  wrote in message
>  :
>
>  >   Failover too.  See http://msdn.microsoft.com/library/en-us/adminsql/ad_c
lustering_7t9v.asp.
>  >
>  >Rich
>  >
>  >  "Ellen K."  wrote in message
news:hi2n91ls9oid6pk6ltj4oiue65m9f9do3d{at}4ax.com...
>  >  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