• Article

Backup.Action Property

Gets or sets the type of backup to be performed.

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

Syntax

'Declaration
Public Property Action As BackupActionType
    Get
    Set
'Usage
Dim instance As Backup
Dim value As BackupActionType

value = instance.Action

instance.Action = value

public BackupActionType Action { get; set; }

public:
property BackupActionType Action {
    BackupActionType get ();
    void set (BackupActionType value);
}

member Action : BackupActionType with get, set

function get Action () : BackupActionType
function set Action (value : BackupActionType)

Property Value

Type: Microsoft.SqlServer.Management.Smo.BackupActionType
A BackupActionType object representing the type of backup to be performed. By default the value is set to Database.

Remarks

Microsoft SQL Server can back up an entire database, that portion of a database changed after the last backup, one or more operating system files containing table or index data, or the transaction log of a database.

The value of the Action property determines applicability and interpretation of related Backup object properties.

Examples

VB

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2AdventureWorks2008R22008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2AdventureWorks2008R22008R2")
'Define a Backup object variable. 
Dim bk As New Backup
'Specify the type of backup, the description, the name, and the database to be backed up.
bk.Action = BackupActionType.Database

PowerShell

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