SQL Server 2000 Quickly moved from 100mb switch to 1000mb switch

SQL Server 2000 Quickly moved from 100mb switch to 1000mb switch

Post by TmV4d » Fri, 09 Sep 2005 05:39:02


My network Administrator has asked me if SQL Server 2000 can quickly be
changed to different switch without scheduling down time.

I thought it was an interesting question. Can SQL Server 2000 running on
Server 2000 handle a quick change from one network switch to another network
switch. It would simply be inplugging the Server's cable and plugging it into
the new switch.

Any information would be helpful.

Thanks in advance,
Aaron
 
 
 

SQL Server 2000 Quickly moved from 100mb switch to 1000mb switch

Post by Rick Sawte » Fri, 09 Sep 2005 05:46:05


A couple of items here.

1. If your NIC card can autosense, then you might be able to get away with
this. That said, you should turn auto-sensing off on your NIC cards to
ensure that you always know what speed you are connecting at.


Rick Sawtell
MCT, MCSD, MCDBA

 
 
 

SQL Server 2000 Quickly moved from 100mb switch to 1000mb switch

Post by Geoff N. H » Fri, 09 Sep 2005 05:55:14

If it is a clustered host, it will fault any SQL instances on that box that
use that NIC.

If you change the IP address, you will have to restart the SQL service.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP