ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 143440

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine 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. 

Attachments