Friday, January 28, 2011

Does the full backup truncate transaction log?

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?

0 comments:

Post a Comment