Video Screencast Help

Microsoft SQL Full & Incr Backup Transaction Log not removed

Created: 01 Apr 2013 | 1 comment


we have Microsoft SQL 2008 server and Backup Exec 2012 server.

we have set Full Backup of Microsoft SQL Server databases only on Monday 2 PM and Incremental Backup Tue to Friday 2PM.

Today (on Monday 1 apr 2013 at 2pm) Full backup run successfully but when i go to the data folder transaction logs are still their and not reduced the size.

what should i do to remove the transaction logs once the full backup done.

or i ;m doing anything wrong. next backup will be incremental and on tuesday 2 apr 2013 at  2PM



Operating Systems:

Comments 1 CommentJump to latest comment

Jaydeep S's picture

Backup Exec will perform a transaction log backup and also truncate the logs. However, it will not truncate the log file size as in not shrink it. For this you will need to run the DBCC ShrinkFile command and get the size down. This is by design.

Edit - Here is another link that will help you