Microsoft Server 2008 SQL Cluster Server Network Card 10G Upgrade

bmlguy
bmlguy used Ask the Experts™
on
Hi,

I'm upgrading our 2 Microsoft Server 2008 R2 Enterprise servers in a clustered configuration running Microsoft SQL Server 2008 Enterprise from four 1GB Broadcom NICs to 10G NICs. The Nics connect to our Sun Storage Appliance via microsoft software iSCSI. I was looking for advice on making this a smooth transition. We currently use mpio with round robin, but will be using teamed 10g nics instead. Below are the steps I believe we need to take.

1. Shut sql services off on both servers.
2. Remove storage drives from cluster manager.
3. Change IP on broadcom nics to auto, disable broadcom NICs
4. Remove MPIO settings.
4. Shut servers down, install 10g cards, restart, install driver, re-ip
5. Configure NICs in team.
6. Reconfigure iSCSI if necessary (not sure if we need to if we use the same IPs)
7. In cluster manager, add storage back and online.
8. Bring SQL services backup
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014

Commented:
Are you sure you're going to use teaming? Well, it's fairly straight forward, you just use StarWind initiator (since MS initiator doesn't support teaming) and follow this simple guide, http://www.rocketdivision.com/info/StarWind_NIC.pdf

Author

Commented:
Actually I read in the best practices guide that they recommend not using teaming, what would the steps be if we stick with MPIO, just want to switch to the 10G nics?
Top Expert 2014
Commented:
I can't think of much you need to do. Just remove IP address from current NICS and delete them from device manager and remove from server, put new ones in and use old IP addresses and reconfigure iSCSI initiator and MPIO same as it is now.

I'd make a full backup first so if for some strange reason it doesn't work you'll be able to restore th current config.

You might have to flush the ARP cache on the storage as the MAC addresses will be different, you could use different IP addresses to avoid this but then you'd have to redo the presentation on the SUN box, but the ARP cache would probably time out after 10 minutes anyway.

Author

Commented:
Turned out to be just that simple

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial