Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Trapped with database size?Trapped with database size?
Previous
 
Next
New Post
4/13/2008 10:59 PM
 

I know this question has been asked in various forms and I've read most of them.

Here goes mine.

I am on godaddy ( I know my first dumb move) and they limit you to a 200 MB database, which they assured me is more than enough for their hundreds of businesses that run DNN. I have my site ready to roll out and I'm already at 105 MB with only 15 users. I have about 20 pages. My site log gets cleared daily and the event log has nothing in it. It says my unallocated space is only 7 MB. They don't give permissions on shared hosting to shrink the database.

 

So with that said here are the only tables with large numbers:

SearchIndexer dbo 02/28/2008 10:02:26 PM PRIMARY 1       
 
SearchItem dbo 02/28/2008 10:02:26 PM PRIMARY 133       
 
SearchItemWord dbo 02/28/2008 10:02:26 PM PRIMARY 2660       
 
SearchItemWordPosition dbo 02/28/2008 10:02:26 PM PRIMARY 6072       
 
SearchWord dbo 02/28/2008 10:02:26 PM PRIMARY 1438

 

Could these possibly be taking up so much space? If so how do I get it under control?

 

The database was only about 30 MB 2 weeks ago when I checked it. When I do a back up with there control panel it makes a file with a .bak extension and that is only 15 MB.

I'm not trying to bored anyone, I'm just giving details to see if any of this is normal or am I headed down a path of disaster when I run out of database space 2 weeks after today, when we handed out 1300 brochures inviting customers to register at our web site.

 

Any help or suggestions or comfort ( if I'm over paranoid ) would be greatly appreciated.

 

Thanks,

Mike

 
New Post
4/14/2008 5:35 AM
 

I'd definately say theres somthing screwy going on with the stats go daddy are showing you... 
I no sql server expert but sure there must be alot of free space if your backup is so small.


John Nicholson
 
New Post
4/14/2008 9:43 AM
 

Check the site log and the transaction log. Usually they get full in case there's a page/module load error or choose to have less issues being logged.

 
New Post
4/14/2008 10:17 AM
 

Wow,

We have WAY more than 20 pages, and 3 portals on our database, and are only using 38MB, something isn't right.


Visit our Website at www.northstarcamaroclub.com
 
New Post
4/14/2008 10:08 PM
 

Thanks everyone for the comments. I must say it has me baffled.

I was wondering if it could be a game they play to try to move you into a dedicated server?

Anyone else have any ideas of what else to look for?

Thanks,

Mike

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Trapped with database size?Trapped with database size?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out