How to shrink SQL Server transaction logs
Sometimes SQL Server transaction logs reach a very large size for the StarTeam database.
To do this, you need a tool to execute sql queries on your StarTeam database (preferably Query Analyzer). Execute "BACKUP LOG pubs TO pubslogbackup", where "pubs" is the database name, in order to make a backup of the transaction log. Then execute "DBCC SHRINKFILE(pubs_log,2)", where "pubs_log" is the name of the log file and 2 is the target size of the log file in MBs. This will shrink the log file to the desired size.
Author: Levi Bowman