Clear Transaction Log MDB

book

Article ID: 32767

calendar_today

Updated On:

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
_______________________________________