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