Clear Transaction Log MDB

Document ID : KB000032767
Last Modified Date : 14/02/2018
Show Technical Document Details

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.

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
_______________________________________