I had my data and log files set to auto grow by 10%. This has caused the transaction logfile to grow to an astronomical 600 GB in size and led to the error
Autogrow of file PFMultilinguaklPOO_log in database PFMultilingual took 523826 milliseconds. Consider using ALTER Database to set a smaller FILEGROWTH for this file
This was causing DB timeouts.
I changed the auto growth setting from 10% to a fixed size to rectify this in the short term but I obviously need to shrink the size of my log file. However when I went to investigate the best method of doing this I noticed a peculiar issue with the file extensions.
My data file has the .LDF extension and my log file has the .MDF extension which is obviously the wrong way round. I'm not sure how this happened. Can the extensions be changed back without any conflict? I am attaching an image to show this.
I was wondering if anyone has seen this before and what the best way to resolve it is.