What should you recommend?

You network contains only servers that run Windows Server 2008. You plan to use only iSCSI for
shared storage. You plan to deploy servers that run Microsoft SQL Server 2005 on the network. You
need to recommend a high-availability solution for the SQL Server 2005 servers to withstand the
failure of any single hardware component. What should you recommend?

A.
Install a two node failover cluster that has multiple network cards.

B.
Install a two node failover cluster that has a dual port teamed network card.

C.
Install a Network Load Balancing cluster that has multiple network cards.

D.
Install a Network Load Balancing cluster that has multiple teamed network cards.

Explanation:
To deploy Microsoft SQL Server 2005 servers on the network and ensure the high-availability of
these servers to withstand the failure of any single hardware component, you need to configure a
two node failover cluster that has multiple network cards. For a failover cluster network, to avoid
having single points of failure, you can connect your cluster nodes by multiple, distinct networks
using multiple network cards. You should not configure a two node failover cluster that has a dual
port teamed network card because Microsoft doesn’t fully support Network Card Teaming in a SQL
Server failover cluster. In network card teaming a number of network cards in a single server operate
as a team. Running multiple heartbeat or public networks on VLAN-configured switches is also not
supported by Microsoft. In this clustering solution, no network can share a single point of failure
with another network. You should configure a failover cluster instead of Network Load balancing
because you need services to remain available if one of the servers fails. Network load balancing can
only divide the load when the number of requests are too high between servers but cannot provide
fault tolerance.
Reduce Downtime: Implement SQL Server 2000 On A Cluster The Cluster Configuration
http://technet.microsoft.com/en-us/magazine/cc160784.aspx
Step-by-Step Guide for Configuring a Two-Node File Server Failover Cluster in Windows
Server 2008 / Hardware requirements for a two-node failover cluster

http://computer.ebooktops.com/step-by-step-guide-for-configuring-a-two-node-file-server-failovercluster-in-windows-server-2008/