Compartir a través de


ShrinkMethod Enumeration

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

Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintaxis

'Declaración
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.

Notas

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.

Plataformas

Plataformas de desarrollo

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Plataformas de destino

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Vea también

Referencia

Microsoft.SqlServer.Management.Smo Namespace