Video Screencast Help

SQL Logs not being deleted after backup

Created: 16 May 2013 | 10 comments
BEI's picture

Hi All,

Something weird has happen to my SQL Logs, they have suddenly stoped being deleted after the backup, creating us issues with full log store.

Any suggestions would be appreciated.

Windows server 2008 Standard; SQL 10.0.5512.0.( 2008 SP3 patch 7))

Operating Systems:

Comments 10 CommentsJump to latest comment

VJware's picture

How did you check if the transaction logs were not truncated ? Are you referring to the physical .ldf file ?

If yes, the physical size of this file remains unchanged as BE truncates the virtual transaction logs.

Secondly, in the backup definition, is the job method set to incremental - log backup ?

pkh's picture

The .ldf will always be present and will never be deleted.  Perhaps you should clarify what you mean by deleted.

ZeRoC00L's picture

Create an SQL task that shrinks the logfiles:

If this response answers your concern, please mark it as a "solution"

BEI's picture

Sorry, I mean clear the logs.

it's just when I run the sharepoint backup it complains that the logs are full, even after the sql has been fully backed up.

I have a seperate SQL Log backup job for this as well as a seperate job for the rest of the server.

I have a full, diff and incremental SQL jobs running, they all come up with green tick when the job is finished.


pkh's picture

If you have a log backup job, this should truncate the logs.  What makes you think that the logs are not being truncated?  If you are worried about the size of the logs being the same as before, you have to to use

dbcc shrinkfile

to recover the space.  See this document

You might want to read my article below and check that your log backups are set up correctly.

VJware's picture

Check the volume which is hosting the physical .ldf file for the above mentioned dBs. Is there sufficient free space ?

BEI's picture


Yes, it appears to be a space issue.

I just can't figure out why the logs fileld up, should the BE clear the logs after each full backup?


BEI's picture

Hi all,

For the moment I changed to simple mode untill we work out why the logs were not truncated.