We have a SQL database of 6GB with a LDF file of 54GB. I have tried to shrink the database and log file, but when I choose shrink filetype LOG, and press start, the shrinking is finished in 2 seconds and I have the feeling that nothing happened. The file is still 54GB.
How can I reduce the filesize?
Is this logfile really necessary?