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.