I had an issue where the max DB size was too small 4GB due to using sql 2005 express so i read up and found 2008 has 10GB.  So I upgraded to 2008 R2 and then the DB size instantly grew to 10GB overnight.  Not sure if it is error logs building up or what.  I changed the password to a harder one and tried to make the initial size smaller but still goes to 10GB, tried to shrink no luck.  I am about to reinstall most all other DB's with DNN running are only 60 megabytes.  I would not think this one would be more than 100mb so why is it so HUGE?  I never had a problem until after updating to 6.2.  I am not saying 6.2 is the problem but it is very strange this problem has accured.

 

Could not allocate space for object 'dbo.dnn_EventLog'.'PK_dnn_EventLogMaster' in database 'Dnndb' because the 'PRIMARY' filegroup is full.

I have been getting this error which causes the problems but my medaling with the DB may have buggered it up even more.

I cant even access the website now... site down.  Please help.

Thank you.

You should also cleaning the eventlog table from time to time.  If you don't do this your database spaces crowed up and you lose performence. 10Gb restictions are only for the express versions. 

---

Regards

Matthias

DNN MVP

www.aarsys.de

Metro7 Skin

ShoutCastStats Module for DNN

Great thanks for the help. It must be event logs filling up in DNN because the SQL log is fine and small. The db file is what is expanding. Yes I am using express and I know of the limitations but for the DB to go from maybe 200mb to 4GB is odd and then for the DB to go from 4GB to10 GB in a day or two is even odder... thats a hell of a lot of events being logged. Its more like a SQL injection or something filling up the DB. It feels more like a bug or an attach on the database.

I have tried to shrink the db but it does not effect the size at all.

I will run a few tests as you all described I appreciate your help and concern.

Thank you.