Shrinking the db_ControlManager_log.ldf File Size on Microsoft SQL Server 2008 (or later)

  1. Back up the Control Manager database using the SQL Server Management Studio.
  2. Purge the transaction log.
  3. On the SQL Server, click Programs > SQL Server Management Studio to open the SQL Server Management Studio.
  4. Select the SQL server and specify the Windows authentication if prompted.
  5. Right-click db_ControlManager and select Properties.

    The Properties dialog box appears.

  6. Click Options.

    The Options work area appears.

  7. Select Simple from the Recovery model: list.
  8. Click OK.
  9. Check the db_ControlManager_log.ldf file size. It should be 10MB.