Shrink db_controlmanager_log.ldf Using SQL Server Enterprise Manager

The transaction log file for the Control Manager database is …\data\db_ControlManager_log.LDF. SQL Server generates the transaction log as part of its normal operation.

db_ControlManager_log.LDF contains all managed product transactions using db_ControlManager.mdf.

By default, the transaction log file has no file size limit on the SQL Server configuration. This leads to filling up the available disk space.

To shrink the db_controlmanager_log.ldf file size:

1. Back up the Control Manager database using the SQL Server Enterprise Manager.

2. Purge the transaction log.

3. On the SQL Server, click Start > Programs > MS SQL Server to open the Query Analyzer.

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)

• 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 equal to 10MB.