Fast Grow to SharePoint Database Log Files

About 2 month ago,the SQL Server drivers had enough space. Suddenly, I noticed that it’s capacity became full !!
I tried to check what’s the reason of the fast grow for driver space  where no new files added to server lately .

I thought the reason may be from Logs files that grow based on the amount of transaction on server.
I went back to the SQL Server database path , then make sort with size desc.

dbpath

I noticed SharePoint_Config_log.ldf  file size is about 14 GB.

Capacity

As best practice you could check the possible responses to a full transaction log and suggested how to avoid it in the future. but if you need to frees the physical log file size you should follow the mentioned steps below : Continue reading Fast Grow to SharePoint Database Log Files

Advertisements