Problem
You’ve ran out of disk space on the drive where the tempdb files are located.
Solution
You need to move the tempdb files to a new location with sufficient disk space.
- Execute the following query:
USE master; GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = '[new_path]\tempdb.mdf'); GO ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = '[new_path]\templog.ldf'); GO
- Stop and restart the instance of SQL Server.
- Once the service has been restarted, verify the changes using this query:
sp_helpdb tempdb
without restart ?
Yes, you don’t need to restart the server; just the service.