Good Evening Gentlemen!!

And a happy and successful 2000 to you all.


I'm unable to logon to my Re-Invent hosted sites again, is this again their problem with a too small database allowance?


Cheers

Olle..

Unhandled Error

Error Details

File
Error	Could not allocate space for object 'dbo.DNN450_EventLog'.'PK_EventLogMaster' in database 'goldcoastwebwiz' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Yes, you will need to free up some space and/or reconfigure your database so that it can grow when filled.

From the Host Menu -> SQL, run these commands:

(1) truncate table Eventlog
(2) truncate table SiteLog

You may need to do a backup/restore of your database, using an option on backup that frees up deleted space.

 

Thanks Joe

Can you please give me the full Query String for the commands.

 

Hope it works without backup / Reinstal.

It's Re-invent I'm stuck with   still so I have no access to the database for backup or restore.

Thanks..

Olle...

 

 

 

Sure.  Just go to the SQL page (Under Host menu) and, one at a time, type in each of those two lines and click the execute button.

The SQL 2005 database Re-invent Provides is 175MB and is included for FREE. Including FREE database backup and restore services. Backups are performed every 24 hours. If the customer requires more disk space he can contact our Sales Dept for additional space which is priced at a low $5/mo per 150MB additional. DNN Sites typically can use lots of space if all the events are logged in the database causing the database size to grow quickly. Setting up tasks to purge events can offset this issue. We've found the 175MB limit included with the free database is enough space for over 90% of the customer sites we host.

We're sorry this person feels like they are stuck with us. A quick look at his uptime has his sites at 100% since he started with us, 100% uptime on Email and his support has been personally responded to within minutes of any issue, including his ticket support regarding this same question.

Re-invent Technologies LLC
DNN Hosting Specialists
http://www.re-invent.com

 

Hi Joe

Did that a few times but get this error:

"There is an error in your query?

???????

Cheers

Olle...

You'll see in the error that the DNN install uses an object qualifier for the database tables called DNN450. This is to differentiate the DNN tables from other tables you may have in your database and was probably done at installation time. So to correctly run the query you need to type:

truncate table DNN450_Eventlog

and

truncate table DNN450_SiteLog

Re-invent Technologies LLC
DNN Hosting Specialists
http://www.re-invent.com

Thank You

That DNN450 did the trick.

No confirmation, but no errors -  so I assume the code executed properly.

I have now deleted 3 portals / websites, and run this code.
Will see if I can get a report on Database size now.

Cheers..


Olle..

 

 

 

Hello,

You may once checkout this tutorial to ensure your log files do not grow too large:
Site logs, Event logs and Scheduler

Thanks to Lee and Reinvent2 for posting better instructions that I did.

I'll also add another resource - Mitchel Sellers' Blog.  If you look there, you will also find SQL scripts that will give you various table sizes.

Just wanted to say I love this site! Gentlemen, thank you for the info here; It came in useful today.

We're glad that it's helpful to you!