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)

public enum BackupCompressionOptions

Member nameDescription
Default

Value = 0. Use the default backup compression server configuration.

Off

Value = 2. Disable the backup compression.

On

Value = 1. Enable the backup compression.

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

Return to top
Show: