Shrink db_ControlManager.mdf and db_ControlManager.ldf Using SQL Commands

Execute the following SQL commands if you are using MSDE or if you prefer to use SQL commands to prevent db_ControlManager.mdf and db_ControlManager.ldf from occupying excessive disk space.

To shrink db_ControlManager.mdf and db_ControlManager.ldf, execute these SQL commands using a SQL query tool:

Alter Database db_controlManager set recovery FULL

Backup log db_controlManager with truncate_only

DBCC shrinkDatabase(db_controlManager)

EXEC sp_dboption 'db_ControlManager', 'trunc. log on chkpt.', 'TRUE'

Alter Database db_controlManager set recovery simple

Alter Database db_controlManager set auto_shrink on