Compartir a través de

  • Artículo

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 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