I've got a database with a data file size of 674 MB and a transaction log of 6.1 GB. The transaction log is about 10 times bigger than the data file.
The transaction log settings can be seen in the image below.
The server is constantly running out of space and this transaction log takes up about 11% of the total disk space. I'd like to make this transaction log file smaller.
Can I simply just change the "Maximum file size" by switching to Restrict file growth [MB]: and set the size to say 80 MB?