what is the difference between dump tran with no_log and dump tran with
truncate_only?

-Rp©

You should always use truncate_only. There are times when there is
absolutely no space left in the tran log, and you will have to use the
no_log option which truncates the tran log but does not write into the
transaction log. A dump tran with truncate_only does write into the tran
log.

Karl


"Rajesh" <r@h.c> wrote in message
newsC%Pa.2541$3G5.1228@nwrdny03.gnilink.net...
> what is the difference between dump tran with no_log and dump tran with
> truncate_only?
>
> -Rp©
>
>