Automic Workload Automation Database File (*.ldf) is growing every hour .How to reduce this growth and prevent growing in future ?

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Automic Workload Automation Database File (*.ldf) is growing every hour . Currently it is showing 800 GB of growth. How to reduce this growth and prevent growing in future? Database is on MSSQL.

Environment

Release : 12.2

Component : AUTOMATION ENGINE

Resolution

Please perform below steps on DB

1. Take a Full Backup of DB

2. Change Database recovery model to simple using below query. 

ALTER DATABASE AUTOMIC SET RECOVERY SIMPLE: to switch to simple recovery mode ( Use your DB name at AUTOMIC). 

 3. Shrink the Automic Transaction log file ( For example as below. Use your log file name in place of automic_log)

DBCC SHRINKFILE (automic_log, 1)

Above will Help in Resolving the issue.