What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and In real time when we go to truncate the log?

Reemi

• Apr 10th, 2007

 

dump tran database to physical name will make of the transaction that have occured against your database since the last transaction log dump

when we use dump tran database with truncate_only ,no copy of transaction is made. The option truncate_only will truncate the log gracefully. It check pionts the database before truncating the log.

The option no_log does not check point the database before truncatingthe log.