Changing the initial size of log files

Posted on

Question :

I am changing the initial size of log files but it goes back to its previous size. Can somebody please let me know what do I need to do so that it gets the new size?


Answer :

If a SQL log file size reduces unexpectedly:

  • Disable the auto-shrink option on the DB if it is set (a best practice anyway)
  • Look for maintenance plans with a Shrink Log step and remove that step for your DB
  • Look for SQL Agent jobs that are shrinking log files, and modify them to exclude your DB

[Edit] Background, question was asked here initially:

Issue is log being increased to 2GB, but automagically shrinking.

Leave a Reply

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