SQL Server with minimal configuration
There are time that the SQL Server instance might not be able to start up due to tempdb files are not accessable. To change the tempdb file location, you can start up the instance with minimal configuration, using parameter -f
net start mssql$NamedInstance -f You can also use trace flag 3608 that tells SQL Server not to start up/recover any database but master.
Once the instance is start up, you can then connect using either SQLCMD for SSMS to change the tempdb file location.
Posted by John Liu Sunday, June 11, 2023