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.