You are an Enterprise administrator for contoso.com. The corporate network of the company runs two Windows Server 2008 servers.
You have been asked to configure the Windows Server 2008 servers in such a way that they support the installation of Microsoft SQL Server 2005 and provide redundancy for SQL services if a single server fails. (Select two. Each correct answer will present a part of the solution.)
Which of the following options would you choose to accomplish this task?
A.
Install a full installation of Windows Server 2008 Standard Edition on the servers.
B.
Install a full installation of Windows Server 2008 Enterprise Edition on the servers.
C.
Install a Server Core installation of Windows Server 2008 Enterprise Edition on the servers.
D.
Configure Network Load Balancing on the servers.
E.
Configure failover clusters on the servers.
Explanation:
To configure the Windows Server 2008 servers in such a way that they support the installation of Microsoft SQL Server 2005 and provide redundancy for SQL services if a single server fails, you need to install a full installation of Windows Server 2008 Enterprise Edition on the servers. Configure failover clusters on the servers.
Failover clustering is a process in which the operating system and SQL Server 2008 work together to provide availability in the event of an application failure, hardware failure, or operating-system error. Failover clustering provides hardware redundancy through a configuration in which mission-critical resources are transferred from a failing machine to an equally configured server automatically.
Reference: SQL Server 2008 Pricing and Licensing/ PASSIVE SERVERS / FAILOVER SUPPORT
http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx.