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)
Syntax
'Bildirim
Public Enumeration ShrinkMethod
public enum ShrinkMethod
public enum class ShrinkMethod
public enum ShrinkMethod
public enum ShrinkMethod
Members
Member name | Description |
---|---|
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. |
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.