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?

Interview Candidate
Apr 2nd, 2007
3
5279

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

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.