2005 MDF File Size Multiplying out of Control

Question

2005 MDF File Size Multiplying out of Control

jon morrissette

Grasshopper

Points: 16
More actions
July 5, 2006 at 6:57 pm

#173302

I have a SQL 2005 database file that was <100 mb a few weeks ago, then grew to 200, then 400mb and is now 1.5 GB. I have no idea why this database is multiplying in size. It surely is not because of data being entered. Can anyone help me out and get this thing under control?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Keith Risman SSC Veteran Points: 287 More actions · Answer 1

Is data being entered? If so, what mechanism is entering the data?, Is there an application that connects that has had recent configuration changes?

AndrewMurphy SSCertifiable Points: 5586 More actions · Answer 2

When you say database file....do you mean the "data" or the "log" portion.

What backup/recovery option have you in place. This can affect your database size.

Emil Fridriksson Mr or Mrs. 500 Points: 547 More actions · Answer 3

I've noticed that my indexes fragment alot faster in SQL Server 2005. Couldn't this just be caused by very fragmented indexes?

jon morrissette Grasshopper Points: 16 More actions · Answer 4

I am running a content management web portal application. I am definitely talking about the MDF and not the LDF files, those log files can get wild too. A minimal amount of data is entered every day. The software can write an error log entry and/or a site log entry whenever a user visits. An individual may update content--which is pure text.

The file has grown frmo 200mb, to 400, to 1000 and was as high as 2.5 GB in a matter of a week. Last night I went through the database and noticed the sitelog and error log tables were each around 500 MB. Keep in mind that these tables contain the same exact data as when the database was 200 mb in size. I deleted the entries and that has reduced the size of the database file to 400-500mb. But still, I know it is at least twice as big as it should be.

I have been checking properties of all my tables and do not know where the space is hiding. I am minimally proficient in SQL server and am using default settings. Thanks for your replies in advance.

Chandra Adi Mulya Grasshopper Points: 11 More actions · Answer 5

Hi there, I have the same issue as yours. It's the mdf file. It has grown till 7 GB, but when I shrink, only < 200MB. Few days later, it will grow exponentially again. It occures only for this database only. I do not know what cause this thing.