-
Notifications
You must be signed in to change notification settings - Fork 10
Setup System Temp Folder
Setup SQL Folder Structure | Manual Install | Setup All Users Temp Folder Next |
---|
FineBuild can set the location of the Windows \Temp folder so that it is more accessible when needed for troubleshooting.
The same \Temp folder will be used for all user temporary files, so there is a single place to look for and manage these files.
Processing of System Temp Folder relates to Process Id 1GE in the FineBuild1Preparation script.
This processing is controlled by the following parameter:
SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
---|---|---|---|---|
SQL2019 | /SetupTempWin: | Yes | Yes | Yes |
SQL2017 | /SetupTempWin: | Yes | Yes | Yes |
SQL2016 | /SetupTempWin: | Yes | Yes | Yes |
SQL2014 | /SetupTempWin: | Yes | Yes | Yes |
SQL2012 | /SetupTempWin: | Yes | Yes | Yes |
SQL2008R2 | /SetupTempWin: | Yes | Yes | Yes |
SQL2008 | /SetupTempWin: | Yes | Yes | Yes |
SQL2005 | /SetupTempWin: | Yes | Yes | Yes |
FineBuild uses the following parameter to help setup the System Temp folder:
Parameter | Default Value | Description |
---|---|---|
/DrvTempWin: | C | Drive location for System Temp folder |
The following steps show what you would have to do to setup System Temp Folder manually. FineBuild does all of this work for you automatically.
-
Ensure the system Temp folder is placed on the /DrvTemp: drive (eg /DrvTemp:T)
Create the folder T:\Temp if it does not already exist
-
Check if the environment variables have been set to use T:\Temp
If they are not pointing to T:\Temp then change them using the process below. All accounts that are associated with SQL Server batch jobs should be set to use the system Temp folder, as the SQL Server service account expects to find certain files in this location
-
Right-click on the Computer icon and select Properties
Click on the Advanced tab then click on the Environment Variables button. Check the User variables section
If TEMP and TMP are not pointing to T:\Temp, select each variable in turn and click on Edit. Change the value of the variable to T:\Temp as shown. Click OK to save the new settings
-
Scroll down in the System variables section
If TEMP and TMP are not pointing to T:\Temp, select each variable in turn and click on Edit. Change the value of the variable to T:\Temp as shown. Click OK to save the new settings.
-
The final setup for these variables is shown below
Copyright FineBuild Team © 2014 - 2019. License and Acknowledgements
Previous Setup SQL Folder Structure | Top | Setup All Users Temp Folder Next |
---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP