Previous Setup No Drive Indexing Manual Install Setup System Temp Folder Next

Setup SQL Folder Structure

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. 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.
High Level Folder Sub-Folder
E:\Program Files
F:\SQLFiles MSSQL.MSSQLSERVER.FTData
I:\SQLFiles MSSQL.MSSQLSERVER.Backup\AdHocBackup
MSSQL.MSSQLSERVER.Backup\SystemDataBackup
MSSQL.MSSQLSERVER.Backup\Data
MSSQL.MSSQLSERVER.Backup\Log
MSSQL.MSSQLSERVER.Backup\Reports
J:\SQLFiles MSSQL.MSSQLSERVER.Log
K:\SQLFiles MSSQL.MSSQLSERVER.Data\msdb
T:\SQLFiles MSSQL.MSSQLSERVER.Data\tempdb

The following folders will be created for Analysis Services if a Main Instance Server Build is being performed.
High Level Folder Sub-Folder
I:\SQLFiles MSAS.MSSQLSERVER.Backup\AdHocBackup
J:\SQLFiles MSAS.MSSQLSERVER.Log
K:\SQLFiles MSAS.MSSQLSERVER.Data

The following folders will be created for Reporting Services if a Main Instance Server Build is being performed.
High Level Folder Sub-Folder
J:\SQLFiles MSSQL.MSSQLSERVER.Log\ReportServer
MSSQL.MSSQLSERVER.Log\ReportServerTempDB
K:\SQLFiles MSSQL.MSSQLSERVER.Data\ReportServer
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.
High Level Folder Sub-Folder
F:\SQLFiles MSSQL.name.FTData
I:\SQLFiles MSSQL.name.Backup\AdHocBackup
MSSQL.name.Backup\SystemDataBackup
MSSQL.name.Backup\Data
MSSQL.name.Backup\Log
MSSQL.name.Backup\Reports
J:\SQLFiles MSSQL.name.Log
K:\SQLFiles MSSQL.name.Data\msdb
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.
High Level Folder Sub-Folder
E:\DBAFiles SQL Server Management Studio\Custom Reports
Scripts
Servers

Copyright © 2014 Edward Vassie. License and Acknowledgements
Previous Setup No Drive Indexing Top Setup System Temp Folder Next

Last edited Oct 8, 2014 at 10:15 AM by EdVassie, version 2