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
_______________________________________