Video Screencast Help

Incremental log backup for SQL 2005 and truncation - BE 2012

Created: 12 Feb 2013 • Updated: 26 Feb 2013 | 3 comments
This issue has been solved. See solution.

Hey all ,

When we configure a full backup of sql 2005 database followed by an incremental log backup , is it going to truncate the transaction logs after the incremental log backup ?

Thanks in Advance

Jose

 

Comments 3 CommentsJump to latest comment

pkh's picture

Yes.  The logs will be truncated.

SOLUTION
josek's picture

Thank you pkh. I missed to mention that the SQL 2005 instance in question is used for share point . Hope still truncation would happen.

Thanks

pkh's picture

Yes.  Truncation will occur regardless of what the databaseis used for.