Hello everyone.

Been along time since ive been around these forums, but after a long away on trips and works around the world im about to startup a gaming community that was alive with over 2000 active registered members and  about 30 000 players about 9months agoo. The gaming servers got hacked (8 CounterStrike Source servers and 2 Ranking/stats servers)in a sensetive moment when the organization was in the midle of changing the management group, and after the servers got hacked there was simply no one who had the time nor the skills and power to reinstall everything etc.

The community fell into a big sleep. :(

Anyway people are asking and we even have some new sponsors at our doorstep now who wants us to get back online.

Unfortunally im the only one left of the original webdeveloping team, and i was never the database or programming dude, i only took care of the design and media on the site, as my skills in programming and Database knowhow ends at the HTML level.

i know my way around DoTNetNuke pritty well but the hardcore coding behind it is way above my level.

Anyway sry for blabering like this.

I have a big problem now. When i enter the site i get this error msg:

I understand that the databse is full and i have checked the size and it is about 4GB in size (4000MB).
We are using a dedicated server on brinkster and as i understand "SQL Server Express" as the limit seems to be just 4GB.

I have tried and go into the hosting settings and switch of the databse loging and set the event log to only save 10days of logs.
After i did this i noticed the site runs alitle faster but still wery slow, 20-30sec for each page load and sometimes even moore.

I went ahead and starting to delete some modules that i thought could be the reason why the site was so slow and then alll of a sudden i get this error msg
above and now i cant even log in.

How can i cleanup the database? and with what?
and isnt 4GB really big?? i mean shouldent it only keep some small Text data?

Remember my skills in SQL is really limited i dont know any commands.
The program i use to check the size of the database is called: SQL server Management Studio Express CTP

sry for my english and blabbering. :)

Thank you.

/Rickard

Sweden

Thank you so much.

i used the Query thingy in the SQL program and put in the
truncates for both EventLog and SiteLog. and here are the results. :)

Before the truncates command.

Database info:
Name__________xxxxx
Status__________Normal
Owner__________xx
DateCreated_____2005
Size____________4301.00MB
Space available___0000.09MB

After the truncate command:

Database info:
Name__________xxxxx
Status__________Normal
Owner__________xx
DateCreated_____2005
Size____________4301.00MB
Space available___3554.55MB

Does this mean that i have deleted 3.5GB of logs?

The site is now accesible again, thank you. but its still really slow to go araound on the site. i read araound that this could be due to old version of DNN i think we are using 3.4 or something like that.

ill contact you thru your website contact form if you dont mind.

thnx again.

/Rickard
Sweden