You are the database administrator of your company. You want to configure an eight-node failover cluster for SQLServer 2008 in your network.
Which version of SQL Server 2008 should you use to achieve this objective?
A.
SQL Server 2008 Express Edition
B.
SQL Server 2008 Enterprise Edition
C.
SQL Server 2008 Standard Edition
D.
SQL Server 2008 Web Edition
Explanation:
You should use SQL Server 2008 Enterprise Edition. Failover clusters are used for high availability of data. Toinstall a SQL Server 2008 failover cluster, you must have Microsoft Cluster Server (MSCS) configured on at leastone of the nodes in the cluster. Additionally, you must be using SQL Server 2008 Enterprise Edition or SQLServer 2008 Standard Edition in conjunction with MSCS. The Enterprise Edition of SQL Server supports eight-node failover clusters, and the Standard Edition supports two-node failover clusters. In this scenario, you want toinstall an eight-node failover cluster. Therefore, you must use SQL Server 2008 Enterprise Edition. After installinga failover cluster, you should confirm whether the nodes are able to failover. To test the failover manually, you canmanually cause a hardware error to occur. There are several conditions that can cause hardware errors, includinga broken connection or network cable, a faulty network interface card, changes made to firewall configuration, andunavailability of the drive on which the transaction log is stored. You should not use SQL Server 2008 Express Edition, SQL Server 2008 Standard Edition, or SQL Server 2008Web Edition because these editions of SQL Server 2008 do not support eight-node clusters. Only the EnterpriseEdition or the Standard Edition of SQL Server 2008 can be used to configure failover clusters.
Objective:
Implementing High AvailabilitySub-Objective:
Implement database mirroring.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Getting Started > Initial Installation > Planning a SQL ServerInstallation > High Availability Solutions Overview > Getting Started with SQL Server 2008 Failover Clustering >Before Installing Failover Clustering