White Papers

BP1014 Enhancing SQL Server Protection using Dell EqualLogic Snapshot Smart Copies
10
3.1 Storage volume layout
A single pool was created from each array. Table 1 lists the volumes and Figure 2 shows the volume
layout.
Table 1 – Storage volumes
Volume
Size
Purpose
Data Pool (PS6000XV RAID10)
Datavol1
100GB
Masterdata, msdb and model database
Sqldb2-vol1
100GB
Database files
Sqldb2-vol2
100GB
Database files
Sqldb2-vol3
100GB
Database files
Sqldb2-logvol
100GB
Transaction Log files
Backup Pool (PS6500E RAID 50)
Bkpvol1
1024GB
Store Database backup files and backup of
transaction logs
sqlsvr
100GB
SQL Server® software binaries
tempvol1
100GB
SQL Server® tempdata
templates
1024GB
Virtual machine templates
Figure 2 – Storage Volumes