Shrinking the db_ControlManager_log.ldf File Size on Windows Server 2008/2005 SP 3

  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 > Microsoft SQL Server 2008/2005 > 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.