Can we delete .NDF file?

Question

You can use DBCC SHRINKFILE with the EMPTY FILE option which will migrate the data to all of the other files in the same filegroup. After this completes no data should be in the secondary file and you can use an alter database to remove the file. Hi , Yes , you can do that . 8 янв. 2010 г.

What is a .NDF file?

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 .

Can I delete SQL Server database secondary data file?

Right click on the database, choose Properties and a database property window will open. Choose Files from the left side pane, click on the file you want to remove from the right side pane and click the Remove button at the bottom of the window.

How do I delete MDF files?

In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance. Expand Databases, right-click the database from which to delete the file, and then click Properties. Select the Files page. In the Database files grid, select the file to delete and then click Remove.

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.

Expert · Answer