Is it safe to delete TempDB MDF?

Question

Is it safe to delete tempdb MDF? 3 Answers. No, you cannot delete the tempdb mdf file. If you need to shrink the file again, restart SQL Server, and then run DBCC SHRINKFILE() .

Can we delete tempdb MDF?

All tempdb files are re-created during startup. However, they are empty and can be removed. To remove additional files in tempdb, use the ALTER DATABASE command by using the REMOVE FILE option. Use the DBCC SHRINKDATABASE command to shrink the tempdb database.

Can I delete MDF files?

Manually delete mdf and ldf files. Right click on database in SSMS and click 'Delete'.

What is tempdb MDF used for?

TempDB is used by the server for operations such as storing temporary and work tables, ordering records, storing records' versions, etc'. If the TempDB is growing, then the server needs more space in it.

Can I delete tempdb NDF files?

Only when the file is not used it can be removed. You can also just remove the file from the properties of the database. When you restart the SQL Server service the [tempdb] is (re-)created.

Expert · Answer