ShrinkMethod Enumeration

 

The ShrinkMethod enumeration contains values that are used to specify the method that is used shrink a database file.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public enum ShrinkMethod

Member nameDescription
Default

Data in pages located at the end of a file is moved to pages earlier in the file. Files are truncated to reflect allocated space.

EmptyFile

Migrates all of the data from the referenced file to other files in the same filegroup. (DataFileand LogFile objects only).

NoTruncate

Data in pages located at the end of a file is moved to pages earlier in the file.

TruncateOnly

Data distribution is not affected. Files are truncated to reflect allocated space, recovering free space at the end of any file.

The ShrinkMethod enumeration class is served by the Shrink method.

Return to top
Show: