Freigeben über


Backup.Action-Eigenschaft

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)

Eigenschaftswert

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

Hinweise

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.

Beispiele

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

Siehe auch

Verweis

Backup Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

BACKUP (Transact-SQL)