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 AdventureWorks2012 database.
Dim db As Database
db = srv.Databases("AdventureWorks2012")
'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("AdventureWorks2012")
$bk = new-object Microsoft.SqlServer.Management.Smo.Backup
$bk.Action = [Microsoft.SqlServer.Management.Smo.BackupActionType]::Database
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace