Log Autogrowths bigger than log size, but no shrinks to explain how
2
votes
1
answer
83
views
I have a database with a logfile size of 1GB. I implemented some logging of AutoGrowths to eventually setup some notifications for when a database autogrows.
What I'm experiencing though, is that SQL Server is saying there were autogrowths of the log file, but the filesize of the log file is not actually changing. There are enough autogrowths to have grown my file to 12GB in size since the beginning of the year, but my file is still only 1GB.
Does anyone know how/why this would happen?
Microsoft SQL Server 2017 (RTM-CU16) (KB4508218) - 14.0.3223.3 (X64) Jul 12 2019 17:43:08 Copyright (C) 2017 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor)
There haven't been any autoshrinks, or manual shrinks of the log file.


Asked by Todd Histed
(31 rep)
Jan 13, 2020, 02:47 PM
Last activity: Jan 14, 2020, 09:29 PM
Last activity: Jan 14, 2020, 09:29 PM