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.

In addition to your .MDF file, you will have an accompanying .LDF. The .LDF contains database log information, which SQL Server uses to maintain database integrity. If you have this file, make ...