Setup SQL Folder Structure - SQL-FineBuild/Common GitHub Wiki
| Previous Setup No Drive Indexing | Manual Install | Setup System Temp Folder Next |
|---|
FineBuild can setup the folder structure needed for SQL Server.
The folders described below will be created. Permissions will be added later during Setup Folder Permissions processing. The SQL Naming Standards give an explanation of the folder names that are used.
FineBuild SQL Folder Structure Processing
Processing of SQL Folder Structure relates to Process Id 1G in the FineBuild1Preparation script, and is always performed.
SQL FineBuild will create the folders that are needed for the build you are performing.
All of the examples show the /Vol...parameter used to specify the drive letter. You can use whatever drive letters, shares, etc that are convenient at your site. Please see Vol Parameters for more details.
- Main Instance Server Build Folders
- Additional Named Instance Server Build Folders
- Workstation Build Folders
- Client Tools Only Build Folders
Manual Setup SQL Folder Structure Processing
The following steps show what you would have to do to setup SQL Folder Structure manually. FineBuild does all of this work for you automatically.
Main Instance Server Build Folders
The following folders will be created for SQL Server database engine if a Main Instance Server Build is being performed.
| /Vol... | High Level Folder | Sub-Folder |
|---|---|---|
| /VolProg:E | E:\Program Files | |
| /VolDataFT:F | F:\SQLFiles | MSSQL.MSSQLSERVER.FTData |
| /VolBackup:I | I:\SQLFiles | MSSQL.MSSQLSERVER.Backup\AdHocBackup |
| MSSQL.MSSQLSERVER.Backup\SystemDataBackup | ||
| MSSQL.MSSQLSERVER.Backup\Data | ||
| MSSQL.MSSQLSERVER.Backup\Log | ||
| MSSQL.MSSQLSERVER.Backup\Reports | ||
| /VolLog:J | J:\SQLFiles | MSSQL.MSSQLSERVER.Log |
| /VolData:K | K:\SQLFiles | MSSQL.MSSQLSERVER.Data\msdb |
| /VolTemp:T | T:\SQLFiles | MSSQL.MSSQLSERVER.Data\tempdb |
The following folders will be created for Analysis Services if a Main Instance Server Build is being performed.
| /Vol... | High Level Folder | Sub-Folder |
|---|---|---|
| /VolBackupAS:I | I:\SQLFiles | MSAS.MSSQLSERVER.Backup\AdHocBackup |
| /VolLogAS:J | J:\SQLFiles | MSAS.MSSQLSERVER.Log |
| /VolDataAS:K | K:\SQLFiles | MSAS.MSSQLSERVER.Data |
The following folders will be created for Reporting Services if a Main Instance Server Build is being performed.
| /Vol... | High Level Folder | Sub-Folder |
|---|---|---|
| /VolData:K | K:\SQLFiles | MSSQL.MSSQLSERVER.Data\ReportServer |
| /VolTemp:T | T:\SQLFiles | MSSQL.MSSQLSERVER.Data\ ReportServerTempDB |
Additional Named Instance Server Build Folders
The following folders will be created for SQL Server database engine if an Additional Named Instance Server Build is being performed. In the table below, use the instance name (e.g. HR) in place of name.
| /Vol... | High Level Folder | Sub-Folder |
|---|---|---|
| /VolDataFT:F | F:\SQLFiles | MSSQL.name.FTData |
| /VolBackup:I | I:\SQLFiles | MSSQL.name.Backup\AdHocBackup |
| MSSQL.name.Backup\SystemDataBackup | ||
| MSSQL.name.Backup\Data | ||
| MSSQL.name.Backup\Log | ||
| MSSQL.name.Backup\Reports | ||
| /VolLog:J | J:\SQLFiles | MSSQL.name.Log |
| /VolData:K | K:\SQLFiles | MSSQL.name.Data\msdb |
| /VolTemp:T | T:\SQLFiles | MSSQL.name.Data\tempdb |
Workstation Build Folders
The folders described at both Main Instance Server Build Folders and Client Tools Only Build Folders should be created, but with all folders normally placed on the System drive.
Client Tools Only Build Folders
The following folders will be created if a Client Tools Only Build is being performed.
| /Vol... | High Level Folder | Sub-Folder |
|---|---|---|
| /VolDBA:E | E:\DBAFiles | SQL Server Management Studio\Custom Reports |
| Scripts | ||
| Servers |
Copyright FineBuild Team © 2014 - 2019. License and Acknowledgements
| Previous Setup No Drive Indexing | Top | Setup System Temp Folder Next |
|---|