Configure SQL Instance Database Properties - SQL-FineBuild/Common GitHub Wiki
| Previous Configure SQL Instance Connection Properties | Manual Configuration | Configure SQL Instance Advanced Properties Next |
|---|
FineBuild can Configure Database Properties of the SQL Server Instance.
The SQL Instance Database properties should be reviewed to confirm that they have not been changed from the default values shown.
FineBuild Configure SQL Instance Database Properties
The SQL Instance Database Properties configuration relates to Process Id 5BD and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2017 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2016 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2014 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2012 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2008R2 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2008 | /SetupSQLInst: | Yes | Yes | N/A |
| SQL2005 | /SetupSQLInst: | Yes | Yes | N/A |
In order to maintain compatibility with older versions of SQL FineBuild, the parameter /ConfigSQLInst: can also be used.
FineBuild also uses the following parameters to help configure SQL Database Properties:
| Parameter | Default | Description |
|---|---|---|
| /VolData: | Drive letter for database data files. See /Vol... Parameters | |
| /VolLog: | Drive letter for database log files. See /Vol... Parameters | |
| /DirSQL: | SQLFiles | High-level folder name for SQL Server files |
In order to maintain compatibility with older versions of SQL FineBuild, the parameters /Drv...: can also be used.
The /VolData:, /VolLog: and /DirSQL: parameters are used during the SQL Server install process to define the folders used for database files, as shown below:
| Model | Example |
|---|---|
| /VolData: \ /DirSQL: \MSSQL.MSSQLSERVER.Data | J:\SQLFiles\MSSQL.MSSQLSERVER.Data |
| /VolLog: \ /DirSQL: \MSSQL.MSSQLSERVER.Log | K:\SQLFiles\MSSQL.MSSQLSERVER.Log |
Manual Configure SQL Instance Database Properties
The following steps show what you would have to do for manual SQL Instance Database Properties configuration. FineBuild does all of this work for you automatically.
-
Select the Database tab
The Database properties should not be changed from the default values shown. For a named instance user the instance name in place of MSSQLSERVER
Property Example Data J:\SQLFiles\MSSQL.MSSQLSERVER.Data Log K:\SQLFiles\MSSQL.MSSQLSERVER.Log 
-
Click OK to save any changes made
Copyright FineBuild Team © 2013 - 2020. License and Acknowledgements
| Previous Configure SQL Instance Connection Properties | Top | Configure SQL Instance Advanced Properties Next |
|---|