Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

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:

 

http://www.symantec.com/business/support/index?page=content&id=TECH82950

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.

 

Regards

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

http://www.symantec.com/docs/TECH82950

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

https://www-secure.symantec.com/connect/articles/h...

BEI's picture

Hi pkh,

Thanks for all your input and support for all my threads.

I get en error when backing up server farm.

V-79-57344-33938 - The transaction log for database 'User Profile Service Application_ProfileDB_6ca16d9721304ea78906622cbb4f1994' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

V-79-57344-33938 - The transaction log for database 'Search_Service_Application_CrawlStoreDB_d2fc9160cf0d402a8b81b08e3d8ba62e' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Regards

pkh's picture

Did you, as suggested by the error messge, go to the particular column and see why the log space cannot be re-used?

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

Hi,

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?

Regards

 

BEI's picture

Hi all,

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

Regards