Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Incremental log backup for SQL 2005 and truncation - BE 2012

Created: 11 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.