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.