Shrink Transaction Logs

You do NOT need to run this (I already did), but you might be interested in this SQL to shrink transaction logs. You do need to do a backup of the databases after you truncate them (I'm not concerned since these old databases are lookup only - no new data should be written to them).

USE MASTER
GO

BACKUP LOG
    file
WITH TRUNCATE_ONLY
GO

USE db
GO

DBCC SHRINKFILE ( 'dbfile' )
GO
USE Master
GO

I used the following code to generate the list of files in the database.

SELECT 'SELECT name from ' + rtrim ( name ) + '..sysfiles'
FROM sysdatabases
WHERE name LIKE 'dbfile%'
ORDER BY name

Don't forget to back-up the database once you're finished as well. A FULL database backup should be done!