I have a database that for some reason the initial Log size appears to be changing on its own. I want it set to 1024 MB and I have set it to that and closed the Database properties window. I then go back into the database properties window and verify that my change is saved and it is. Then in a few hours or few days, the value gets changed, sometimes larger and sometime smaller. For example I set it to 1024 MB this morning and now it is showing 370 MB just 6 hours later. Last week it went from 1024 MB to 180,369 MB.
I am in a very small office and no one else is changing this value so something is doing it within SQL. The database is part of a replication to another server but I cant imagine that would effect it. Any ideas one why this would happen?