I have a customer using my software that is experiencing timeout issues when executing certain queries. I expanded the command timeout and the connection timeout properties, but they're still having issues. When I looked a little closer at their system, I found that the log file for their system was about 50 GB and their database only about 5 mb. They have another computer that is running the same software, but has not experienced the same growth in the log file.
I tried to shrink the log file using SSMS, but it didn't affect the size of the file in any way I could tell. Any suggestions on how to shrink the log file and any possible reasons this exponential growth of the log file on this computer is occurring would be appreciated. Thanks.