I have a DNN MDF file that is 222+ Gig (yes I said Gig).  I have followed the video instructions (thanks Lee) on the event logs.  My Event Logs account for 99% of the MDF file.   The event log has over 27 million rows of records and the site log has over 2 million rows of records.

I have tried to delete the event log, but it is way too big, I then tried to use the truncate table command, but the server issues a Timeout Expired error.  I have raised my Query time-out setting from 300 all the way up to 76800 but the truncate table still issues a time expired error.

 

My question is this:  Would it be possible to rename the current eventlog table to eventlog-bad, and then import a fresh empty eventlog table from a different dnn installation.  If so, then would I just delete the eventlog-bad table from the database?

 

I am using SQL 2000 and DNN version 3.2.2

 

Thanks in advance for your help.

this is not something I have done before, if you attempt it make sure you create a full backup first. - in fact I would create a backup of your live database, install it on a local installation and then experiment with the database on your local computer, you may find this easier to work with.