SQL Server v2014. I have attempted to relocate the tempdb files from C to another drive. The ALTER statements performed fine, and the restart completed without error as well. But now that I am trying to adjust the size of the file on the new drive, the system tells me there is not enough space -- because it still thinks they are on the C drive.
This is the error I receive when I attempt to ALTER the size of the tempdb log file:
Msg 5149, Level 16, State 3, Line 41
MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file
'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER
Yet at the very same time, sp_helpfile says the files are:
I have relocated the tempdb countless times before, but I have never run into this problem. Are there any Experts who can assist?