Can I Simply Change A Transaction Log From Unrestricted to Restricted? 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?
I prefer restricting to unrestricted.

If some process goes awry, then I don't want the log file to grow and grow and fill the disk up. I'd rather the DB stopped working than the entire Server/SQL Server Instance.

However, in this case you have a different issue: most likely "FULL" recovery and no log backups. Change to simple, shrink the log to, say 500MB, allow growth at 250MB, set a maximum of 2GB.