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.