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.