Backup Process Control Constants (SQLDMO_BACKUP_TYPE)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Backup process control constants define, at the highest level, the type of backup performed using the Backup object. Specification of files and maintenance of the transaction log provides greater control over the backup operation.

Constant Value Description

SQLDMOBackup_Database

0

Backs up the database.

SQLDMOBackup_Files

2

Backs up only specified files.

SQLDMOBackup_Differential

1

Backs up rows changed after the most recent full database or differential backup.

SQLDMOBackup_Log

3

Backs up only the database transaction log.