Initial size of the log file is changing back to its original size.

TheDBLearningGuy 171 Reputation points

I have a database whose log file initial size is 1MB, I have changed it to 4MB. But when I check the initial size after some time its size shows again to 1 MB. The auto shrink option is set to false for the database. Could any please let me know why it is changing back to 1 MB.

Note: Model database's logfile initial size is at 1MB.

Thanks in advance!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,802 questions
{count} votes

2 answers

Sort by: Most helpful
  1. 4,291 Reputation points MVP

    Where do you see this "initial" size? If you are using an old SSMS, then it incorrectly say "Initial", then it in fact show you the current size.

    Just to be certain, check the file size on disk as well. If you see that the file is smaller then it was, then something did a shrink on that tile. Possibly autoshrink, a scheduled job, or somebody doing this manually.

    1 person found this answer helpful.

  2. CarrinWu-MSFT 6,811 Reputation points

    Hi @KrishneGowdaKV-7600,

    Which version of SQL Server do you used? I have been tested in my side, the log file size will not change if I modified the size value. And the size means current log file size, see below:

    Best regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments