How do I reduce the size of an NDF file?

Question

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. 9 мар. 2011 г.

Can you shrink an NDF file?

Shrinking MDF and NDF file is possible and there is no chance of data loss. It is not always advisable to shrink those file as those files are usually growing. There are cases when one database is separated in multiple database of any large table is dropped from database MDF and NDF can contain large empty space.

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.

How do I shrink a data file?

To shrink a data or log file1In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.2Expand Databases and then right-click the database that you want to shrink.3Point to Tasks, point to Shrink, and then click Files. ... 4Select the file type and file name.Shrink a File - SQL Server | Microsoft Docs

How do I shrink an MDF file?

How to Shrink .1Connect to the SQL Server Management Studio, Go to Databases.2Select the desired database that needs to be shrunk.3Right-click on the database, Select Tasks >> Shrink >> Files.4Make sure that you choose Data File type for shrinking MDF File.5The options of Shrink Option are as follows:Steps to Shrink MDF File in SQL Server

Expert · Answer