Can I delete NDF files?

What are NDF files?

What is a NDF file? A file wiht . ndf extension is a secondary database file used by Microsoft SQL Server to store user data. NDF is secondary storage file because SQL server stores user specified data in primary storage file known as MDF.

How do I delete an NDF file in SQL Server?

Restart SQL Server Instances and then execute the following query.1USE tempdb;2GO.3DBCC SHRINKFILE('tempdev2', EMPTYFILE)4GO.5USE master;6GO.7ALTER DATABASE tempdb.8REMOVE FILE tempdev2;How to Add or Remove TempDB Data Files - C# Corner

Can I delete tempdb NDF?

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.

How do I reduce the size of an NDF file?

For test purposes, create a database with Initial size (. ndf file size) as 10 MB and try to shrink it to 1 MB using DBCC shrinkfile. -- Truncate the log by changing the database recovery model to SIMPLE. -- Shrink the truncated log file to 1 MB.