Compartir a través de


Backup.Action Propiedad

Gets or sets the type of backup to be performed.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.SmoExtended (en Microsoft.SqlServer.SmoExtended.dll)

Sintaxis

'Declaración
Public Property Action As BackupActionType 
    Get 
    Set
'Uso
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)

Valor de la propiedad

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

Comentarios

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.

Ejemplos

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

Vea también

Referencia

Backup Clase

Espacio de nombres Microsoft.SqlServer.Management.Smo

Otros recursos

BACKUP (Transact-SQL)