MS SQL database includes MDF file and LDF file. 


MDF is actual data of an application and LDF file is a transaction log file which records the queries and the result. It can be optimized through "Shrink option for the file.


<How To Check Size of LDF and Reduce the size of the file>

1. Run SQL Management studio as administrator
2. Copy the below query and click on [Execute]
sp_helpdb BioStar;

3. Confirm the size of BioStar_log

4. Stop BioStar Server

5. Mouse right click on BioStar DB name and go Tasks>Shrink>Files

6. Click File Type>Log and click on [OK]


7. Copy the below query and click on [Execute] and check the result.
sp_helpdb BioStar;