Export (0) Print
Expand All
Expand Minimize

ShrinkMethod Enumeration

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

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

public enum ShrinkMethod
public enum ShrinkMethod
public enum ShrinkMethod

Member nameDescription
DefaultData in pages located at the end of a file is moved to pages earlier in the file. Files are truncated to reflect allocated space.
EmptyFileMigrates all of the data from the referenced file to other files in the same filegroup. (DataFileand LogFile objects only).
NoTruncateData in pages located at the end of a file is moved to pages earlier in the file.
TruncateOnlyData 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.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.


Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft