Home / server / Questions / 188739
Accepted
hyty
Asked: 2010-10-08 11:10:09 +0800 CST

Does the full backup truncate transaction log?

  • 772

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

BACKUP DATABASE AdventureWorks
    TO Adventurewks
GO

Or do I have to take a log backup separately?

BACKUP LOG AdventureWorks
   TO Adventurewks;
GO

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

sql-server backup sql-server-2008 backup-restoration transaction-log

1 Answers

  1. Best Answer

    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

    • 1