Clear Transaction Log MDB

Document ID : KB000032767
Last Modified Date : 21/05/2019
Show Technical Document Details
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.
Instructions:

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
_______________________________________