Shrinking 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.

Alter Database db_ControlManager set recovery FULL

Backup log db_ControlManager with truncate_only

DBCC shrinkDatabase(db_ControlManager)

Note:

The third command might take longer depending on the size of the database.

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