SQL-DMO
Backup Process Control Constants (SQLDMO_BACKUP_TYPE)
Backup process control constants define, at the highest level, the type of backup performed using the Backup object. Greater control over the backup operation is provided by specification of files and maintenance of the transaction log performed.
| Constant | Value | Description |
|---|---|---|
| SQLDMOBackup_Database | 0 | Back up the database |
| SQLDMOBackup_Files | 2 | Back up only specified files |
| SQLDMOBackup_Differential | 1 | Back up rows changed after the most recent full database or differential backup |
| SQLDMOBackup_Log | 3 | Back up only the database transaction log |