Owner's Manual

Deployment Guide 29
Follow these steps to create a resource group for SQL Server 2005 that contains all of the data, log, and
tempdb disks that will be used by the clustered SQL Server instance:
1
Right-click one of the groups and rename to SQL Server.
2 Identify the disks that should be in the SQL Server Group from the other additional groups, and move
each additional disk by clicking and dragging to the SQL Server Group.
The goal is to have all available SQL disks on one Resource Group.
Installing SQL Server 2005 Database
Pre-Install Preparation
NOTE: Using multiple files is a best practice. The names provided below are just examples.
1 Create <n> folders on each of the external disks assigned to the database where <n> is equal to the
number of cores in the processor. For example, if the processor is dual core, then create two folders on
each of the external disks.
2 Name each of the folders that you created in step 10 using the following naming convention:
MSS_DATA_<number>
where <number> is a number that increments for each folder. For example, MSS_DATA_1 and
MSS_DATA_2 and so on.
The following is an example file system layout for the database for a node with two dual core
processors:
E:\(MSS_DATA_1), (MSS_DATA_2)
F:\(MSS_DATA_3), (MSS_DATA_4)
3 Create two folders on the external disk assigned to the log. Name the folders as follows:
MSS_LOG1
TEMPDB_LOG1
4
Create a folder on the external disk assigned for the tempdb database and name it as follows:
TEMPDB_DATA_1
Configuring a Windows Account to Enable Instant File Initialization
To enable instant file initialization for data or tempdb files in SQL Server 2005, you must run the SQL
Server 2005 service account under a Windows account and assign the Windows
SE_MANAGE_VOLUME_NAME permission to that Windows account.
1
Log into the SQL Server 2005 using an account that has administrative privileges.
2 Click Start , point to Settings , and then click Control Panel .