Compartilhar via


Action Property (Backup)

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

The Action property controls the type of backup performed against a Microsoft SQL Server database.

Sintaxe

object
.
Action [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list.

  • value
    A long integer specifying the backup as described in Settings.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetAction(SQLDMO_BACKUP_TYPE* pRetVal);
HRESULT SetAction(SQLDMO_BACKUP_TYPE NewValue);

Settings

Constant

Value

Description

SQLDMOBackup_Database

0

Backs up the database.

SQLDMOBackup_Files

2

Backs up only specified files.

SQLDMOBackup_Incremental

1

Backs up rows changed after the most recent full database or differential backup.

SQLDMOBackup_Log

3

Backs up only the database transaction log.

Comentários

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. For example, if Action is SQLDMOBackup_Files, either the DatabaseFileGroups or DatabaseFiles property must specify filegroups or files backed up.

Applies To: