Setup Volume Labels
| Previous Setup No Windows Global Access | Manual Install | Setup Volume Shares Next |
|---|
FineBuild can set up the labels of local volumes needed for SQL Server.
FineBuild sets up volume labels to make it easier for the DBA to see what type of data is intended to be stored on each volume. The names used for the volume labels are also used to Setup Volume Shares and to setup cluster storage volume names.
Processing of Volume Labels relates to Process Id 1FA in the FineBuild1Preparation script, and is always performed automatically.
FineBuild uses the following parameters to help configure Volume Labels:
| Volume Param | Default | Label Param | Default | Usage |
|---|---|---|---|---|
| /VolSys: | System Drive | LabSys | System | Will always be the Windows System Drive |
| /VolDTC: | (none) | LabDTC | MSDTC | DTC Cluster files (Only relevant for cluster install) |
| /VolProg: | VolSys | LabProg | Programs | SQL Server program files |
| /VolBackup: | VolProg | LabBackup | Backup | Database backup files |
| /VolBackupAS | VolBackup | LabBackupAS | AS Backup | SQL AS database backup files |
| /VolBPE: | VolProg | LabBPE | BPE | SQL Bufferpool Extension File |
| /VolData: | VolProg | LabData | SQL Data | SQL DB database data (MDF) files |
| /VolDataAS: | VolData | LabDataAS | AS Data | SQL AS database data files |
| /VolDataFS: | VolData | LabDataFS | FS Data | SQL Server Filestream files |
| /VolDataFT: | VolData | LabDataFT | FT Data | SQL Server Full Text files |
| /VolSysDB: | VolData | LabSysDB | SQL SysDB | System DB Files |
| /VolLog: | VolData | LabLog | SQL Log | SQL DB database log (LDF) files |
| /VolLogAS: | VolLog | LabLogAS | AS Log | SQL AS database log files |
| /VolLogTemp: | VolLog | LabLogTemp | Temp Log | SQL tempdb log files |
| /VolTemp: | VolData | LabLog | SQL Temp | SQL tempdb data files |
| /VolTempAS: | VolTemp | LabTempAS | AS Temp | AS temporary files |
| /VolTempWin: | VolProg | LabTempWin | Temp | Windows \Temp folder |
| /VolDBA: | VolProg | LabDBA | DBA Misc | DBA Miscellaneous files |
In order to maintain compatibility with older versions of SQL FineBuild, /Drv... can be used in place of /Vol....
The values of the /Lab... parameters above will be given a suffix when required in order to uniquely identify them when compared to similar values.
- If a list of drive letters is supplied for the /VolData: parameter, the label for each of these drives will be suffixed with the drive letter
- If a Named Instance is installed, the label for each drive associated with the instance will be suffixed with the instance name
If a drive is supplied for more than one /Vol... parameter, then the first label that is applied will be retained.
Examples of the labels used are given below:
| Vol Parameter | SQL Instance | Drive Letter | Volume Label |
|---|---|---|---|
| /VolData:JK | MSSQLSERVER | J: | SQL DataJ |
| K: | SQL DataK | ||
| /VolLogAS:F | HR | F: | AS Log-HR |
| /VolDBA:D | HR | D: | DBA Misc |
The following steps show what you would have to do to setup Volume Labels manually. FineBuild does all of this work for you automatically.
Set up the following volume labels.
-
Right-click on each local volume and select Properties
-
Set the volume label as shown in the table above.
Ensure the Compress drive... and Allow Indexing Service... checkboxes are clear, then click OK to save the new volume label.
Copyright FineBuild Team © 2014 - 2018. License and Acknowledgements
| Previous Setup No Windows Global Access | Top | Setup Volume Shares Next |
|---|