September 29, 2010 at 8:05 am
Does a differential backup truncate the transaction log?
September 29, 2010 at 9:25 am
No. Only a log backup truncates the transaction log.
Greg
September 29, 2010 at 9:26 am
Piling on a bit...
No, neither differential or full backups affect the transaction log.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 29, 2010 at 9:42 am
Neither will truncate the Transaction Log. To do this, you would need to perform a Transaction Log backup and then you can truncate the log file, but keep in mind the log file is that size for a particular reason. At one time or another it needed that much space to record the changes.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
September 29, 2010 at 11:50 am
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply