I'm attempting to install SQL Server 2016 SP2 on a newly created EC2 instance. I'm using a configuration file I previously generated. In the configuration file I've specified where I'd like the TempDB files to be created along with the Database Root data and log directories. That looks like this:
; The number of Database Engine TempDB files. SQLTEMPDBFILECOUNT="8" ; Specifies the initial size of a Database Engine TempDB data file in MB. SQLTEMPDBFILESIZE="88500" ; Specifies the automatic growth increment of each Database Engine TempDB data file in MB. SQLTEMPDBFILEGROWTH="0" ; Specifies the initial size of the Database Engine TempDB log file in MB. SQLTEMPDBLOGFILESIZE="88500" ; Specifies the automatic growth increment of the Database Engine TempDB log file in MB. SQLTEMPDBLOGFILEGROWTH="0" ; Directories for Database Engine TempDB files. SQLTEMPDBDIR="T:\Data" ; Directory for the Database Engine TempDB log files. SQLTEMPDBLOGDIR="T:\Log" ; The Database Engine root data directory. INSTALLSQLDATADIR="O:\Data" ; Default directory for the Database Engine user database logs. SQLUSERDBLOGDIR="O:\Log"
After the installation I get this error message:
MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file 'O:\Data\MSSQL13.BI\MSSQL\DATA\templog.ldf'.
The log output from the installation has the same directory paths specified in the ConfigurationFile for TempDB and for the the user data/log directories.
For the life of me I cannot understand why the TempDB files are being created in the filepath specified in the error message.