I have a database on SQL Server 2000 which is about 6GB but the LDF file is 100GB. I have been doing some research on the matter and found out that I have several options.

It also means you haven’t read my blog article on how to avoid ginormous transaction logs, and now have to take the steps necessary to shrink the transaction log (.ldf) file.