Configuration.DefaultBackupCompression Property

  • Article

 

Applies To: SQL Server 2016 Preview

Gets the ConfigProperty object that is used to set the default backup compression configuration option.

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

Syntax

public ConfigProperty DefaultBackupCompression { get; }

public:
property ConfigProperty^ DefaultBackupCompression {
    ConfigProperty^ get();
}

member DefaultBackupCompression : ConfigProperty with get

Public ReadOnly Property DefaultBackupCompression As ConfigProperty

Property Value

Type: Microsoft.SqlServer.Management.Smo.ConfigProperty

A ConfigProperty object that specifies the settings for the backup compression default configuration option.

Remarks

This property specifies the compression value:

Default - Use the default backup compression server configuration

On - Enable the backup compression

Off - Disable the backup compression

Examples

Legacy Code Example

Configuring SQL Server in SMO

See Also

Configuration Class
Microsoft.SqlServer.Management.Smo Namespace
Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)

Return to top