Action Property (Backup) (SQL-DMO)

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

Applies To

Backup Object

Syntax

object.Action [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value Long integer specifying the backup as described in Settings

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.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetAction(SQLDMO_BACKUP_TYPE* pRetVal);

HRESULT SetAction(SQLDMO_BACKUP_TYPE NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.