Shrinking the db_ControlManager_log.ldf File Size on Microsoft SQL Server 2005

  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 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. On the list, select the db_ControlManager database.
  6. Copy and paste the following SQL script:

    DBCC shrinkDatabase(db_ControlManager)

    BACKUP LOG db_ControlManager WITH TRUNCATE_ONLY DBCC SHRINKFILE(db_ControlManager_Log, 10)

    Note:

    On the SHRINKFILE(db_ControlManager_Log, 10) function, the parameter 10 will be the resulting file size of db_ControlManager_Log.ldf in megabytes (MB).

  7. Click Execute to run the SQL script.
  8. Check the db_ControlManager_log.ldf file size. It should be 10MB.
Parent topic: Shrinking db_ControlManager_log.ldf Using SQL Server Management Studio