I am a developer but have to do DBA stuff now and then.
We had a problem where the Transaction log files of our DBs where increasing to large size of
50GB while the data file (MDF) was only
So I tracked the issue to the file size, the Autogrowth was set to 10% for Log File
According to the Start Kit by BrentOzar, they recommend setting the file size to:
256 MB for Data File
128 MB for Log File
Which I have done.
Currently the DBs are in
Simple Recovery Mode - Which I intend to change to
Full Recovery Mode (and then take regular log backups)
But because the Log Files have grown so large, there is no space on the Hard Disk - I need to make up some space,
The Question is:
Is it okay for me to Shrink some of the log files while they are in Simple Recovery Mode? Because there is alot of free space in some of them
like this one has 99% free space