Propriedade CompressionOption

Gets or sets the compression option for the current backup session and is transient to the Backup Object Microsoft.SqlServer.Management.SmoExtended.Backup

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (em Microsoft.SqlServer.SmoExtended.dll)

Sintaxe

'Declaração
Public Property CompressionOption As BackupCompressionOptions
    Get
    Set
'Uso
Dim instance As Backup
Dim value As BackupCompressionOptions

value = instance.CompressionOption

instance.CompressionOption = value

public BackupCompressionOptions CompressionOption { get; set; }

public:
property BackupCompressionOptions CompressionOption {
    BackupCompressionOptions get ();
    void set (BackupCompressionOptions value);
}

member CompressionOption : BackupCompressionOptions with get, set

function get CompressionOption () : BackupCompressionOptions
function set CompressionOption (value : BackupCompressionOptions)

Valor da propriedade

Tipo: Microsoft.SqlServer.Management.Smo. . :: . .BackupCompressionOptions
Boolean BackupCompressionOptions

Comentários

Member Name	Value	Description
Default	0	Use the default backup compression server configuration
On	1	Enable the backup compression
Off	2	Disable the backup compression

Exemplos

Fazendo backup e restaurando bancos de dados e logs de transações

Consulte também

Referência

Backup Classe

Membros Backup

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

BACKUP (Transact-SQL)