So what would be a nice way to reduce the size of EventLog table..? And Safe Way? Maybe:

DELETE FROM EventLog WHERE LogCreateDate<15/10/2006

Is anything likely to go wrong - in anyone's experience? Or maybe there is a better/nicer way..???

I was going to make a backup before attempting to delete some portals in my db that did not get created properly because of some issue that has yet to be resolved. Well, in WH4L my db backup just hung up. I went and looked at the size at it was over 1GB for only 10 moderately active websites and about 10 child portals for demo sites.

I ran the procedure referenced above and found that my Sitelog and EventLog were nearly 900MB but mostly is shows as Unused space. So what causes this? I have tried to pull up my Sitelog to see what is going on, but it just times out. I want to truncate my sitelog, but for some reason all of a sudden I cannot login to my site. I can get to the Home page but no other pages. What will happen if I truncate the Sitelog without turning off logging? Will it try to log the deletions and compound my problem?

Table                                                   Rows            Tot Space   Used Space                         Unused Space