How to minimize database log file

Few day ago I faced small problem with my some SQL Server database log files which exceed over 50 Gb of size which is for sure not a good idea on a limited storage so to solve this problem we can do simple steps which requires connection throw MS SQL Server management tool  with full permission on you database files to change change database properties for a short period of time, after that to shrink it, and return every thing back to normal so let start:

1. We connect to database server using SQL Server Management Tool

2. Select target Database, right click on properties and from properties window select options and after that we need to change recover model into Simple then click OK to save our changes.

3. after we have changed recording model to simple we can right now to shrink database files to minimize system file size, by right click on database Tasks>Shrink>Database then OK.

after completing this operation we have to return our database modeling to its previous mode repeating steps 1 and 2.

Filed under: