You need to recommend a Windows Server 2008 R2 server configuration that meets the following
requirements:
• Supports the installation of Microsoft SQL Server 2008
• Provides redundancy for SQL services if a single server fails
What should you recommend?
A.
Install a Server Core installation of Windows Server 2008 R2 Enterprise on two servers. Configure
the servers in a failover cluster.
B.
Install a full installation of Windows Server 2008 R2 Standard on two servers. Configure Network
Load Balancing on the two servers.
C.
Install a full installation of Windows Server 2008 R2 Enterprise on two servers. Configure Network
Load Balancing on the two servers.
D.
Install a full installation of Windows Server 2008 R2 Enterprise on two servers. Configure the
servers in a failover cluster.
Explanation:
Fail Over Clustering, which is available on the Enterprise edition (not on standard) will provide fail
over as required.
Windows Server 2008 Enterprise Edition
Windows Server 2008 Enterprise Edition is the version of the operating system targeted at large
businesses. Plan to deploy this version of Windows 2008 on servers that will run applications such as
SQL Server 2008 Enterprise Edition and Exchange Server 2007. These products require the extra
processing power and RAM that Enterprise Edition supports. When planning deployments, consider
Windows Server 2008 Enterprise Edition in situations that require the following technologies
unavailable in Windows Server 2008 Standard Edition:
■ Failover Clustering I-ail over clustering is a technology that allows another server to continue to
service client requests in the event that the original server fails. Clustering is covered in more detail
in Chapter 11. “Clustering and High Availability.” You deploy failover clustering on mission-critical
servers to ensure that important resources are available even if a server hosting those resources
fails.