Posted by ronin 47th on 11/17/05 22:03

Hi group,
In one of the books 'Gurus Guide to Transact SQL' i found this info:

------------------------------------------------------------
TRUNCATE TABLE empties a table without logging row deletions in the
transaction log. It can't be used with
tables referenced by FOREIGN KEY constraints, and it invalidates the
transaction log for the entire database.
Once the transaction log has been invalidated, it can't be backed up
until the next full database backup.
------------------------------------------------------------

Does it mean that the log backup taken after table truncation is an
invalid backup?

Help me! i'm lost....

Thanks in advance
Ronin

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: What looks like a basic SQL query still not resolved
• Prev in forum: Re: What looks like a basic SQL query still not resolved
• Thread view: Log Invalidated after truncate table

[Reply to this message]