SQL Server Performance

does backup in 2005 and later not shrink transaction log?

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Apr 29, 2012.

  1. Trev256b Member

    someone told me that sql server database backup in sql server 2005 and later do not truncate the transaction log. is this true? (i didn't think it was and can't find anything to suggest this is true)
  2. Shehap MVP, MCTS, MCITP SQL Server

    No , it isn't true , it still truncate transaction log backup
  3. Trev256b Member

    Can you provide a link for this as i find conflicting entries online for this?
  4. Luis Martin Moderator

    What kind of proof do yo need?
  5. Trev256b Member

    Just a simple microsoft or msdn link to technically backup and explain my point. As my colleague has a link to backup his incorrect claim. Many thanks.
  6. Luis Martin Moderator

Share This Page