Hello!
I am running a DotNetNuke installation for a friend, and we're using GoDaddy as the service provider. However, over the past years we've been getting error messages frequently, of the "Primary File Group Full" type....This is apparently caused by DotNetNuke filling up our SQL database, I presume...

However, I have a very limited web management console available for doing changes, the DBCC commands are not allowed... And there's a size limitation on the database, fixed to 200MB. The GoDaddy team refuse to provide support, as they claim it's not their responsibility, but the application we're using. So we're pretty much at loss at the moment.

Personally, I'm not much of a database expert, and I know nothing of SQL at all. I am computer literate, so to speak, but not a developer. More of a web designer / potato kind of guy :D So please, if there are things I can or need to do to the database, please give me some "easy to follow" SQL queries, and I'll be able to fun them.

Your help  is tremendously appreciated!

Cheers,
Jon - http://www.clementbass.com/web

Thanks for your answer!
I will look into the blog, maybe there's something I can find out there! :-) Hopefully there is!

The Eventlog is mostly disabled, and I clean it out every now and then. There is no more than 10-20 entries in there each time, so most entries are disabled. There is no activated Search on the site, and the Sitelog is also disabled by default from GoDaddy. So Neither of these should most likely give too much data to the database.

The version of the SQL Server is 2005.

I did a sp_spaceused command, and got the following information out:

database_name database_size unallocated space ***** 227.00 MB 0.00 MB

reserved data index_size unused 204824 KB 198448 KB 5024 KB 1352 KB

you'll need to identify what table(s) have the data as your database size has gone beyond the limit provided for your godaddy account. To do this, you can use an undocumented stored procedure.

sp_msforeachtable "sp_spaceused '?'"

Alternatively the script at http://www.dotnetnuke.com/Community/F... will give you a nice formatted output.

Cathal

---

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US