Web Wiz Support and Community Forums : Forum DB Full https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 21:37:41 +0000 Tue, 04 Mar 2008 17:22:55 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=25393 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Forum DB Full : In that case you want to ask them...]]> https://forums.webwiz.net/forum-db-full_topic25393_post131794.html#131794 Author: WebWiz-Bruce
Subject: 25393
Posted: 04 March 2008 at 5:22pm

In that case you want to ask them to put the recover model on to simple and enable auto shrinking of the database. This will keep the file size down.]]> Tue, 04 Mar 2008 17:22:55 +0000 https://forums.webwiz.net/forum-db-full_topic25393_post131794.html#131794 <![CDATA[Forum DB Full : _popupControl(); Thanks Bruce,...]]> https://forums.webwiz.net/forum-db-full_topic25393_post131793.html#131793 Author: Slugsabi
Subject: 25393
Posted: 04 March 2008 at 5:19pm

_popupControl();Thanks Bruce, will get on that.  Only small as only a few (50) users which usually surfices, even so I will allocate more space and get the providers to shrink as advised.  It's the MS-SQL version, btw.]]> Tue, 04 Mar 2008 17:19:19 +0000 https://forums.webwiz.net/forum-db-full_topic25393_post131793.html#131793 <![CDATA[Forum DB Full : It looks like the database is...]]> https://forums.webwiz.net/forum-db-full_topic25393_post131791.html#131791 Author: WebWiz-Bruce
Subject: 25393
Posted: 04 March 2008 at 5:00pm

It looks like the database is reserving space within it. You have not said what db it is, but ask your web host to shrink the db.

20Mb is not allot anyway, I would also suggest getting a bigger database.
]]> Tue, 04 Mar 2008 17:00:56 +0000 https://forums.webwiz.net/forum-db-full_topic25393_post131791.html#131791 <![CDATA[Forum DB Full : Morning chaps, I keep getting...]]> https://forums.webwiz.net/forum-db-full_topic25393_post131788.html#131788 Author: Slugsabi
Subject: 25393
Posted: 04 March 2008 at 4:30pm

Morning chaps,
 
I keep getting an auto notification from my provider advising that the forum db is nearly full (20.94 of 22.00) used.  Now, I've done the delete old threads et al but still didn't resolve so I ran a sql query to check the tables sizes.  This returned the following:
 
]]> Tue, 04 Mar 2008 16:30:36 +0000https://forums.webwiz.net/forum-db-full_topic25393_post131788.html#131788
namerowsreserved (kb)data (kb)index_size (kb)unused (kb)
tblThread 5049  8904468011523072
tblAuthor 163  432208112112
tblPMMessage 2426  75366632240664
tblBuddyList 93  888800
tblConfiguration 1  248160
tblDateTimeFormat