Take the 2-minute tour ×

Does the transaction log get truncated when I take a full backup using command

    TO Adventurewks

Or do I have to take a log backup separately?

BACKUP LOG AdventureWorks
   TO Adventurewks;

Or is the log backup just for a point-in-time restore?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

A log backup is needed to truncate the logs.

Here is an article that contains some information on this, http://technet.microsoft.com/en-us/library/ms186865.aspx

share|improve this answer

Your Answer


