Knowledgebase

Search:     Advanced search

Shrinking the SQL Server Transaction Log Size

Article ID: 277  |  Last updated: 25 Apr, 2017

The SQL Server transaction log for a Helix ALM, Helix ALM License Server, or Surround SCM database may become very large, which can cause disk space issues on the database server.

You can use the SQL Server DBCC SHRINKFILE command to reduce the log file size.

  1. Back up the database.
  2. Start SQL Server Management Studio.
  3. In the Object Explorer, right-click the database and choose Properties.
  4. Click Files.
  5. Locate the logical name of the transaction log file. You will use the filename in the DBCC SHRINKFILE command.
  6. Click OK to close the Database Properties dialog box.
  7. In the Object Explorer, right-click the database and choose New Query.
  8. Execute the following query:
    DBCC SHRINKFILE
    BACKUP LOG WITH TRUNCATE_ONLY
    DBCC SHRINKFILE
  9. Perform a full backup of the database.
Article ID: 277  |   Last updated: 25 Apr, 2017
Tags
SQL Server disk space transaction log

Also listed in
folder Surround SCM
folder Helix ALM (formerly TestTrack)

Prev   Next
License Server Functions Incorrectly After Upgrading to Windows...     License Server Not Initialized Status