05-16-2013 11:23 PM
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))
05-16-2013 11:48 PM
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 ?
05-16-2013 11:58 PM
The .ldf will always be present and will never be deleted. Perhaps you should clarify what you mean by deleted.
05-17-2013 12:34 AM
Create an SQL task that shrinks the logfiles:
http://www.symantec.com/business/support/index?page=content&id=TECH82950
05-19-2013 05:01 PM
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
05-19-2013 06:31 PM
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
05-19-2013 06:59 PM
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...
Regards
05-20-2013 10:29 PM
Did you, as suggested by the error messge, go to the particular column and see why the log space cannot be re-used?
05-20-2013 10:37 PM
Check the volume which is hosting the physical .ldf file for the above mentioned dBs. Is there sufficient free space ?
05-20-2013 10:41 PM
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
05-20-2013 10:44 PM
Hi all,
For the moment I changed to simple mode untill we work out why the logs were not truncated.
Regards