Can we shrink NDF file SQL Server?

How do you shrink NDF?

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.

How do I shrink the tempdb NDF file?

If more files are added to tempdb, you can shrink them after you restart SQL Server as a service. 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.

Can we shrink data file in SQL Server?

To shrink a data or log file. In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance. Expand Databases and then right-click the database that you want to shrink. Point to Tasks, point to Shrink, and then click Files.

Can we shrink MDF file SQL Server?

In the left pane where your databases are listed, right-click on the "SampleDataBase" and from the "Tasks" option select "Shrink" then "Files", as in the image below. On the next dialog box, make sure the File type is set to "Data" to shrink the mdf file.