bluepaperbag
SSCrazy
Points: 2055
More actions
August 30, 2007 at 1:05 pm
#178252
does sql server truncate the log file when i do a full-db backup?
Lynn Pettis
SSC Guru
Points: 442467
August 30, 2007 at 1:26 pm
#730575
No. Only transaction log backups will truncate the transaction log.
sqldba-294117
Hall of Fame
Points: 3486
August 30, 2007 at 2:20 pm
#730589
if you are using 3rd party backup software like for e.g. Tivoli it truncates TRN LOGs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply