Many times the large size of transaction log file (.ldf) in microsoft sql is too big which leads to performance issues and loss of valuable disk space.therefore it's imperative to periodically do ...

This change improves debugging by providing a log file named according to SQL Server specifications.

Recommended Action If the log file name is important for an app, the app should be updated to expect the standard _log.ldf file name format.

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. Switch to Simple mode ...

I have found some information online that says I need to use SQL server to shrink this file. I did not have SQL server installed on the server.