By default SQL log file size limits are setup to unrestricted.
If you wish to setup a limit, you can do so by following the below. Please be careful when making such changes. Make sure you have a backup of your databases before attempting any changes.
1) Open SQL Enterprise or SQL Server Management Studio
2) Expand databases
3) Right click on the database you wish to set the log size limit on and click properties
4) Click Files
5) Locate your log file in the list. Should be databasename_log
6) Scroll across to the tab named AutoGrowth and click the square button
7) Click restricted file growth and add a limit, click ok
Your post Setup a limit for SQL log file size | Online IT Support was very interesting.. I have your blog now in my bookmarks and I visit your blog again, soon. Take care.
Thanks for the clear instructions
Easy to follow post
Thanks for sharing such a useful bit of instruction!
Do you work in I.T? I bet you do 🙂
Thanks for sharing this. I’m useless at SQL but this is a straight forward task.