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.
Release : 12.2
Component : AUTOMATION ENGINE
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.