Making a backup, deleting the original transaction log

If your database is not involved in replication, and if you have limited disk space on your online computer, you can delete the contents of the online transaction log (truncate the log) when you make a backup. In this case, you need to use every backup copy made since the last full backup during recovery from media failure on the database file.

To make a backup, deleting the transaction log (SQL)

Include the TRANSACTION LOG ONLY clause only if you are making an incremental backup.

The backup copies of the transaction log and database file are placed in backup-directory. If you enter a path, it is relative to the working directory of the database server, not your client application.

To make a backup, deleting the transaction log (Command line)

From the command prompt, enter the following command:

dbbackup -c "connection-string" -x [ -t ] backup-directory

Include the -t option only if you are making an incremental backup.

The backup copies of the transaction log and database file are placed in backup-directory. If you enter a path, it is relative to the directory from which you run the command.