No_Log and With No_Truncate..

What is the difference b/w With No_Log and With No_Truncate..
Thanks
NOOR
On Thu, 5 Aug 2004 02:19:18 -0700, Noor wrote:

>What is the difference b/w With No_Log and With No_Truncate..
>Thanks
>NOOR
>
Hi Noor,
Have you checked Books Online?
NO_LOG | TRUNCATE_ONLY
Removes the inactive part of the log without making a backup copy of it
and truncates the log. This option frees space. Specifying a backup device
is unnecessary because the log backup is not saved. NO_LOG and
TRUNCATE_ONLY are synonyms.
After backing up the log using either NO_LOG or TRUNCATE_ONLY, the changes
recorded in the log are not recoverable. For recovery purposes,
immediately execute BACKUP DATABASE.
NO_TRUNCATE
Allows backing up the log in situations where the database is damaged.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)