Renaming the backup copy of the transaction log during a backup (command line)

Use the dbbackup utility to rename the backup copy of the transaction log, which by default has the same name as the online file. To make a repeatable incremental backup command, rename the backup copy of the transaction log.

Prérequis

You must have the BACKUP DATABASE system privilege.

Contexte et remarques

Alternatively, you can move the backup copy of the transaction log instead of renaming it.

The backup copy of the transaction log is named YYMMDDxx.log, where YY is the year, MM is the month, DD is the day of the month, and xx runs from AA to ZZ, incrementing if there is more than one backup per day. The YYMMDDxx.log file names are used to distinguish between files, not for ordering.

This set of backup options is typically used for databases involved in replication. In addition to making backup copies of the database file and transaction log, the transaction log at backup time is renamed to an offline log, and a new transaction log is started with the same name as the log in use at backup time.

Task

Supply the -n option to dbbackup. For example, the following command makes an incremental backup of a database, renaming the backup copy of the transaction log.
dbbackup -c "connection-string" -r -t -n c:\backup-name

Résultat

The backup copy of the transaction log is renamed.

Renaming the backup copy of the transaction log during a backup (command line)

Task

See also