SQL Logs not being deleted after backup

[BEI]

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))

[VJware]

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]

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

[ZeRoC00L]

Create an SQL task that shrinks the logfiles:

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

[BEI]

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]

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/how-backup-sql-logs-and-truncate-them-be-2012

[BEI]

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_6ca16d9721304ea78906...

V-79-57344-33938 - The transaction log for database 'Search_Service_Application_CrawlStoreDB_d2fc916...

Regards

[pkh]

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

[VJware]

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

[BEI]

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]

Hi all,

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

Regards