YOU ARE INSTALLING SQL SERVER 2008 ON A NEW WINDOWS 2008 CLUSTER....

19. You are installing SQL Server 2008 on a new Windows 2008 cluster. You get

to the disk configuration screen and are unable to configure the tempdb

database to be placed in the C:\MSSQL\MSSQL\Data folder as per your

IT policy. How should you resolve this issue?

A. Add the C drive as a clustered resource using the Windows cluster

administrator. Rerun the SQL Server 2008 installed, selecting the C drive

as a disk resource.

Managing High Availability • Chapter 6 243

B. Install SQL Server with the TEMPDB database on a clustered drive. After

installing SQL Server 2008, change the location of the TEMPDB database

to the C drive and restart the SQL Server.

C. Add a new drive to the cluster as a clustered resource. Use this drive to

host the TEMPDB database.