SQL Database ( 2005 & 2008) datafile doubled in size "automatically"
Posted on 2010-11-24
HI guys -
I have a database on SQL2005 and it doubled in size overnight. Initial file size is 55g, file growth is 1mb/unrestricted. Log file initial size is 4mb growth is 10% restricted growth to 2,097,152.
I have a process that runs at night inserting a few records..maybe 20k max. Last night the data file was 57gb and the log file 4mb (~12k rows were inserted). I checked this morning and the data file size is now 117gb and the log file 5mb.
I have a copy of this database running on SQL2008 on a different server and the same process runs there as well. The initial file size/growth are the same on this server as they are on the 2005 one. The data file did the same thing when the same dataset was inserted. (They're running in parallel for debugging reasons currently, not for production reasons). The log file remained nearly unchanged.
Both are on Windows Server 2008
I shrunk both of them and they went back to their normal size. No problem with that at all.
Is there any logical reason why this would happen? Anything I can do to make sure it doesn't happen again?