Shrink MDF File

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)

/* Get the Logical File Name */

USE AdventureWorks

EXEC sp_helpfile

/* Shrink MDF File of AdventureWorks Database */

DBCC SHRINKFILE (AdventureWorks_Data)

If the above solution is helpful then,accept the answer.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.