Action Property (Backup)

  • 發行項

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。

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

語法

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.

備註

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:

Backup Object