BackupCompressionOptions Enumeration

The BackupCompressionOptions enumeration contains values that are used to specify the backup compression option.

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

Syntax

'Declaration
Public Enumeration BackupCompressionOptions
'Usage
Dim instance As BackupCompressionOptions
public enum BackupCompressionOptions
public enum class BackupCompressionOptions
type BackupCompressionOptions
public enum BackupCompressionOptions

Members

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

Remarks

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