Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Backup.Incremental Property

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)

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.

VB

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
Dim bk As New Backup
bk.Action = BackupActionType.Database
bk.Database = "AdventureWorks2008R2"
bk.Incremental = true

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
$bk = new-object Microsoft.SqlServer.Management.Smo.Backup
$bk.Action = [Microsoft.SqlServer.Management.Smo.BackupActionType]::Database
$bk.Database = "AdventureWorks2008R2"
$bk.Incremental = $TRUE

Community Additions

ADD
Show:
© 2015 Microsoft