The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P48: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Managing High Availability Chapter 6 217 New Noteworthy. Creating Clustered Resource Group During Installation The ability to create the cluster resource group and select the disks for the Resource Group during the SQL Server 2008 installation is a new feature. In prior versions of Microsoft SQL Server you had to manually create the Resource Group and move the hard drives into the resource group. This addition of this feature into the SQL Server installer is a huge plus for SQL Server. By placing this functionality directly into the SQL Server installer as DBAs we now need to rely less on the system administrators who assemble the servers and cluster the Windows operating system to set up the resource groups and hard drives. We can now without having any additional knowledge of the Windows Cluster Administrator tool set up the SQL Server quickly and easily in a Windows Cluster. In the example shown in Figure an existing Resource Group was selected. This Resource Group was created before the SQL Server 2008 installer was launched and this Resource Group has the disks already located in it. 218 Chapter 6 Managing High Availability Figure Cluster Resource Group Screen On the next screen select the disks that you wish to use for the SQL Server. You should select any and all hard drives that you will be using for the SQL Server. Additional hard drives can be added later through the Cluster Manager. As you can see in Figure only disks that do not have other resources dependent on them are available for use by the SQL Server. In this case the Q drive is in use as the quorum and by the MSDTC service. The Q drive can be used by both of these because both of them are in the same Resource Group. Exam Warning Microsoft loves to test on new technology and features. The fact that this is new means that it is more likely to be on the exam. Managing High Availability Chapter 6 219 Figure Cluster Disk Selection On the next screen you select the IP addresses you
