Wednesday, August 5, 2020

CREATE FILE encountered operating system error 3(The system cannot find the path specified.) while attempting to open or create the physical file 'D:\tempDb\Data\tempdb.mdf'.

https://blog.sqlauthority.com/2017/04/27/sql-server-unable-start-sql-service-os-error-5-access-denied-tempdb/

  • run CMD
    • NET START MSSQLSERVER /f /mSQLCMD
    • SQLCMD -S localhost -E
    • ALTER DATABASE tempdb Modify FILE (Name = 'tempdev',FileName = 'C:\tempDB\tempdb.mdf')
    • ALTER DATABASE tempdb Modify FILE (Name = 'templog',FileName = 'C:\tempDB\templog.ldf')

No comments:

Post a Comment