Owner's Manual
Deployment Guide 25
NOTE: Applications utilizing SQL Server as a back end may have specific requirements dictated by the design
characteristics of the application and are beyond the scope of this Deployment Guide. For application-specific
guidelines and recommendations as they relate to physical and logical database layout, please contact your
application provider.
Installing the Host-Based Software Needed for Storage
Follow the documentation accompanying the storage device to install the appropriate host-based storage
software, drivers for storage controller, and multi-path driver software for your storage array. Please refer
to the Solution Deliverables List (SDL) for the latest versions.
Preparing the Disks for Installing the SQL Server 2005 Database
1
Open a Windows command prompt.
2
Type the following at the Windows command prompt:
diskpart
3
Type the following at the DISKPART prompt:
list disk
4
Type the following at the DISKPART prompt:
select disk <n>
where
<n>
is the disk number corresponding to the virtual disks assigned to the host which needs
to be partitioned.
NOTE: EMC recommends aligning the partition at 64. The EMC CX3 default stripe size is 64KB, and the Dell
PowerVault default stripe size is 128KB.
5
Type the following at the DISKPART prompt:
create partition primary align=128
6
Repeat step 3 through step 5 for all other external disks identified in Table 1-4.
7
Close the window for the command prompt.
8
Use the following procedure to assign a drive letter to all external disks.
a
Right-click
My Computer
and select
Manage
.
b
In the
Computer Management
window expand
Storage
and click on
Disk Management
.
c
In the
Disk Management
window, right-click the partition area and select
Change Drive Letter
and Paths.
d
Click
Add
.
e
Click
Assign the following drive letter
and select an appropriate drive letter from the drop-down
menu.
f
Click
OK
.