We use Microsoft SQL Server at work (a mix of 2000 and 2005) and have recently discovered that a couple of our databases have massive log files (.ldf), filling up the disk. In one case it's a 7GB log file for a 200MB database!!
Is there a way to safely reduce the size of them so we can reclaim some disk space? I notice that most of our other databases have 1-5MB log files.