Previous FineBuild Special Builds Upgrade from Old Version of SQL Server Next

SQL Media Alternative Folder Names

The folder names and locations given for SQL Media Preparation are the default values used by FineBuild. However, run-time parameters can be used to supply different folder names or locations.

This page explains how these parameters can be used.

All of the parameter values can be relative path names that relate to the FineBuild folder, but it is recommended that absolute path names are always used. Path names can also be given as share names.

Parameter Comment
/PathAddComp: Path to the folder containing the FineBuild Additional Components
Specify the path and name of the \Additional Components folder if the default value is not being used.
/PathSQLMedia: Path to the folder containing the Microsoft SQL install media
If the SQL install media is on a DVD mounted (for example) on drive D:\, use /PathSQLMedia:D
/PathSQLSP: Path to the folder containing the SQL Server Service Packs and Cumulative Updates
Specify the path and name of the \Service Packs folder if the default value is not being used.

SQL FineBuild will use a process of discovery to find the SQLMedia folder, based on the value of the /Edition parameter and the style of the operating system. The tables below shows how this discovery works.

Table mapping /Edition: value to folder name (For example SQL2016_Std). Either the full edition name or the folder suffix can be used with the /Edition: parameter:

Edition Name /Edition: /Edition: Folder
Business Intelligence "Business Intelligence" BI SQL2016_BI
Data Center "Data Center" DC SQL2008R2_DC
Developer Developer Dev SQL2008_Dev
Enterprise Enterprise Ent SQL2014_Ent
Enterprise Evaluation "Enterprise Evaluation" Eval SQL2005_Eval
Express Express Exp SQL2014_Exp
Standard Standard Std SQL2016_Std
Web Web Web SQL2012_Web
Workgroup Workgroup Wkg SQL2008_Wkg

If no /Edition parameter is given, SQL FineBuild will default to using /Edition:Eval.

The bit style of the operating system and the install language are also included in the discovery process, by the use of further suffixes. SQL FineBuild will search for the most specific media first, then progressively search for less specific media until a suitable install media folder is found.

Normal OS, 32 Bit, German language SQL2005_Std_X86_DEU
Normal OS, 64 Bit, Default language SQL2008R2_Std_X64
Normal OS, 32 Bit, Default language SQL2014_Std_X86
Core OS, default Bit, German language SQL2008R2_Std_Core_DEU
Normal OS, default Bit, German language SQL2016_Ent_DEU
Core OS, default Bit, Default language SQL2014_Ent_Core
Normal OS, default Bit, Default language SQL2012_Web

The example below shows folder names for many SQL Server versions and editions:
SQL Media Folders.png
The Acme SQL Files folder is described in Site SQL Files Folder.

Copyright FineBuild Team © 2012 - 2016. License and Acknowledgements
Previous FineBuild Special Builds Top Upgrade from Old Version of SQL Server Next

Last edited Nov 11, 2016 at 11:13 AM by EdVassie, version 14