Can NDF files be deleted?

Can I delete tempdb NDF files?

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.

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

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.

What are tempdb NDF files?

An NDF file is a user defined secondary database file of Microsoft SQL Server with an extension . ndf, which store user data. Moreover, when the size of the database file growing automatically from its specified size, you can use . ndf file for extra storage and the . ndf file could be stored on a separate disk drive.