Dumping Databases Without Separate Log Segments

When a database does not have a log segment on a separate device from data segments, use dump transaction with truncate_only to remove committed transactions from the log without making a backup copy.

Warning!   dump transaction with truncate_only provides no means to recover your databases. Run dump database at the earliest opportunity to ensure recoverability.

Use with truncate_only on the master, model, and sybsystemprocs databases, which do not have log segments on a separate device from data segments.

You can also use with truncate_only on very small databases that store the transaction log and data on the same device.

Mission-critical user databases should have log segments on a separate device from data segments. Use the log on clause of create database to create a database with a separate log segment, or alter database and sp_logdevice to transfer the log to a separate device.