Shrink MDF File

Question

How do shrink MDF file in SQL Server?

Rajeev Punhani · Answer

Hi Vignesh DBCC SHRINKDATABASE (dbName) Following is the script to shrink single file. DBCC SHRINKFILE (logicalLogFileName) To find logicalLogFileName following command has to be ran. USE dbName EXEC sp_helpfile Let us understand this using database AdventureWorks. /* Shrink Whole AdventureWorks Database */ DBCC SHRINKDATABASE (AdventureWorks) GO /* Get the Logical File Name */ USE AdventureWorks EXEC sp_helpfile GO /* Shrink MDF File of AdventureWorks Database */ DBCC SHRINKFILE (AdventureWorks_Data) GO If the above solution is helpful then accept the answer.