Clear Transaction Log MDB

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager

Issue/Introduction

Issue:

I installed CA ITCM 12.8 with database SQL 2012. I need to reduce the file size of two huge MDB
Database files mdb_log.LDF and mdb.mdf. I have followed steps listed in TEC476219 but it not working.

Please provide steps which is applicable for SQL 2012.

Environment

ITCM All versions running with SQL 2012.

Resolution

Resolution:

Please follow the below steps:

_______________________________________
USE MDB

ALTER DATABASE MDB SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(mdb_log, 1)
ALTER DATABASE MDB SET RECOVERY FULL WITH NO_WAIT
_______________________________________