Commands and System Procedures Used to Back Up Databases

Commands and system procedures used to back up databases.

To

Use

Make routine dumps of the entire database, including the transaction log.

dump database

Make routine dumps of the transaction log, then truncate the inactive portion. The inactive portion of a transaction log is not truncated if dump transaction is running concurrently with dump database.

dump transaction

Dump the transaction log after failure of a database device.

dump transaction with no_truncate

Truncate the log without making a backup, then copy the entire database.

dump transaction with truncate_only

dump database

Truncate the log after your usual method fails due to insufficient log space, then copy the entire database.

dump transaction with no_log

dump database

Respond to the Backup Server volume change messages.

sp_volchanged