Setup SQL Folder Structure Manual Install Setup All Users Temp Folder Next

Setup System Temp Folder

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.

FineBuild System Temp Folder Processing

Processing of System Temp Folder relates to Process Id 1GE in the FineBuild1Preparation script.

This processing is controlled by the following parameter:
Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014 SQL2016
SetupTempWin FULL Yes Yes Yes Yes Yes Yes
SetupTempWin WORKSTATION Yes Yes Yes Yes Yes Yes
SetupTempWin CLIENT Yes Yes Yes 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

Top

Manual Setup System Temp Folder Processing

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.

1) 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.
2) 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.
3) 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.
SetTemp.png
4) 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.
SetSystemTemp.png
5) The final setup for these variables is shown below.
Final.png
Copyright FineBuild Team © 2014 - 2016. License and Acknowledgements
Previous Setup SQL Folder Structure Top Setup All Users Temp Folder Next

Last edited Oct 17, 2016 at 9:47 AM by EdVassie, version 5