Setup a limit for SQL log file size

Reading Time: < 1 minute

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

4 thoughts on “Setup a limit for SQL log file size

  1. 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.

  2. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.