70-647 · Question #76
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…
The correct answer is A. Install a two node failover cluster that has multiple network cards. 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…
Question
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?
Options
- AInstall a two node failover cluster that has multiple network cards.
- BInstall a two node failover cluster that has a dual port teamed network card.
- CInstall a Network Load Balancing cluster that has multiple network cards.
- DInstall a Network Load Balancing cluster that has multiple teamed network cards.
How the community answered
(58 responses)- A72% (42)
- B14% (8)
- C10% (6)
- D3% (2)
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 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 Windows Server 2008 / Hardware requirements for a two-node failover cluster cluster-in-windows-server-2008/
Topics
Community Discussion
No community discussion yet for this question.