| Author |
 Topic  |
|
|
Jon von Nottingham
Starting Member
5 Posts |
 Posted - 14 June 2001 : 23:49:21
|
A few problems:
We recently filled up our database. At the time we were getting this error, but only when someone tried "replying" to a topic:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'FORUM_REPLY' in database 'new_snitz' because the 'PRIMARY' filegroup is full.
/forum/post_info.asp, line 577
Then we cleaned house, deleting 50,000 posts or more. We also deleted 30-50 pages of inactive profiles.
Results- Not good. We bought ourselves a week and freed up very little space, while ticking off some long-time members.
WHAT IS TAKING UP ALL THIS SPACE IN OUR DATABASE? And shouldn't delteting post accomodate for more posting.
Here's a clue perhaps. I can delete posts by a member until I am blue in the face. But let's say this person has 145 posts. That number will show up under their name in their posts. What if I deleted one. It should say 144 right? No it still says 145. Could it be that just because I delete something from my forum, that it really hasn't gone away?
Again, this error only occurs when replying. People can still posts original messages if they want.
Jon
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 June 2001 : 00:14:04
|
How big is your logfile? Every transaction with the SQL Database is logged in a logfile on the SQL Server, which can grow quite large.
Also, deleting a post by a member does not reduce their post count, that is by design.
Also, take a look at this thread: http://forum.snitz.com/forum/link.asp?TOPIC_ID=10428 |
 |
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 15 June 2001 : 00:31:50
|
well, whenever I delete a reply the post count is decreased by one.
<-- Eric -->
InsideWaco.com |
|
|
|
Jon von Nottingham
Starting Member
5 Posts |
Posted - 15 June 2001 : 00:40:46
|
Richard, I am the "other guy" at moontown.I recall freeing up a smidgeon of space after truncating (less than .5 MB)
It got us by for a week, but how does that explain why we can post but not reply?
Jon
Edited by - Jon von Nottingham on 15 June 2001 00:42:03 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 15 June 2001 : 00:52:36
|
| I can only guess that maybe each table is alotted a certain amount of space. Since there are more replies than there are topics, the FORUM_REPLY table will be bigger than the FORUM_TOPICS table. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 15 June 2001 : 01:44:29
|
You can use DBCC CHECKALLOC to see what table is taking up the space. DBCC SHRINKDATABASE may help.
Is your db filesize restricted in the database properties? Just how big is the database file?
======
Doug G
====== |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 June 2001 : 20:09:19
|
The sizing allowance is largely to do with index space, since it affects the primary file group, which is generally where the indexes are.
You should try backing up your log file, this will have the effect of clearing it down.
You could also recreate your indexes and not put them in the primary file group.
Also ask your host to set the truncate log on checkpoint option, this will reduce greatly the speed at which it increases, but will mean you have no backup.
|
|
|
|
Jon von Nottingham
Starting Member
5 Posts |
Posted - 21 June 2001 : 22:59:16
|
Thanks,
will take it all into consideration
|
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 05 July 2001 : 09:46:28
|
quote:
Thanks,
will take it all into consideration
we also experiencedthe same problem. checked everything at our end. called the host and it was messed up at their end. they corrected and it is working fine since. check with your host.
gauravbhabu
There is only one miracle...That is LIFE! |
|
|
| |
Topic |
|
Topic Locked
