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 |