Aller au contenu principal

MS SQL Server problems with truncating logs

Thread needs solution
Contributions: 1
Commentaires: 1



We have a customer, there are running Microsoft Dynamics AX on a Server 2012 R2 with MS SQL Server 2014 and have a heavy load of data (270 GB DB). Currently they have the primary DB, but we have some issue with truncating logs (transaction logs) which is grooving too fast/big.

DB size: 278 GB (D:\)
DB log: (E:\ Currently 190 GB which should be.. 10 GB?)

We are having a backup plan:
Every day repeat every 4 hour(s) from 06:00 until 22:00
With truncating logs enabled.


Why it doesnt truncate/remove the logs when running backup? I have to change the DB til simple mode, for making log file like zero again..


0 Users found this helpful
Contributions: 1
Commentaires: 1


I doesnt get any errors in backup jobs.