Setup SQL Folder Structure

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

Top

---

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

Top

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

Top

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.

Top

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

Top

Copyright FineBuild Team © 2014 - 2019. License and Acknowledgements

Previous Setup No Drive Indexing	Top	Setup System Temp Folder Next