Action Property (Backup)
Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The Action property controls the type of backup performed against a Microsoft SQL Server database.
Syntax
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. |
Hinweise
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.