Skip to main content

MS SQL Server problems with truncating logs

Thread needs solution
Beginner
Posts: 1
Comments: 1

Hello.

 

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
Beginner
Posts: 1
Comments: 1

#1

I doesnt get any errors in backup jobs.