Action Property (Backup)
The Action property controls the type of backup performed against a Microsoft® SQL Server™ database.
Applies To
| Backup Object |
Syntax
object.Action [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
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 | Back up the database |
| SQLDMOBackup_Files | 2 | Back up only specified files |
| SQLDMOBackup_Incremental | 1 | Back up rows changed after the most recent full database or differential backup |
| SQLDMOBackup_Log | 3 | Back up only the database transaction log |
Remarks
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, when Action is SQLDMOBackup_Files, either the DatabaseFileGroups or DatabaseFiles property must specify filegroups or files backed up.