This topic has not yet been rated - Rate this topic

Backup.Incremental Property

SQL Server 2008

Gets or sets a Boolean property value that determines whether to perform a differential backup.

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

Syntax

C++

JScript

public bool Incremental { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether a differential backup will be performed.
If True, only changes since the most recent full or differential backup will be included in the backup operation.
If False (default), a full backup will be performed.

Examples

Backing Up and Restoring Databases and Transaction Logs

Reference

Backup Class

Backup Members

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Using Differential Backups

BACKUP (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD